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
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

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-101007 $or followed by always false $elemMatch can fail pipeline optimization

In Code Review

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

Closed

related to

SERVER-105375 Use EOF plan for alwaysFalse expressions within elemMatch

Closed

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:: 6 Start watching this issue

Created:: Oct 11 2022 06:31:24 PM UTC
Updated:: Aug 12 2025 09:43:17 PM UTC
Resolved:: Nov 16 2023 02:10:23 PM UTC
Confidence Status Last Update:: 15/Nov/23 10:03 AM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates