Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: None
Labels:
None

Assigned Teams:

Query Optimization
Operating System:
ALL
CAR Domain/s:
None

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

When preserveNullAndEmptyArrays is true, a $lookup $unwind pair is an outer join, which we can’t reorder.

is related to

SERVER-114740 Join Optimimization: includeArrayIndex argument to $unwind is disregarded

Needs Scheduling

Assignee:: Unassigned
Reporter:: Hana Pearlman
Participants:: Hana Pearlman
Votes:: 0 Vote for this issue
Watchers:: 3 Start watching this issue

Created:: Dec 01 2025 01:30:45 PM UTC
Updated:: Dec 03 2025 04:53:30 PM UTC