Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 7.3.0-rc0
Affects Version/s: None
Component/s: None
Labels:
None

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
Sprint:
QO 2023-10-16, QO 2023-10-30, QO 2023-11-13, QO 2023-11-27
Linked BF Score:
200

Irina suggested in this comment that {$in: []} is tautologically "false" so it would be nice to optimize the plan to "return an empty result right away" rather than scanning anything.

depends on

SERVER-81863 Avoid a scan of either IDX or a collection if the filter is $alwaysFalse:

Closed

fixes

SERVER-47374 Query with empty in clause performs collection scan

Closed

is related to

SERVER-97911 Query with "_id in empty array" traverses the full collection when given the _id index as a hint

Closed

SERVER-101007 $or followed by always false $elemMatch can fail pipeline optimization

Investigating

Assignee:: Carlos Alonso Pérez

Reporter:: Mohammad Dashti (Inactive)

Participants:: Carlos Alonso Pérez, Githook User, Mohammad Dashti

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Created:: Oct 11 2022 06:31:24 PM UTC

Updated:: Feb 20 2025 04:17:12 PM UTC

Resolved:: Nov 16 2023 02:10:23 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates