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

related to

SERVER-119169 Join Optimisation does not handle correctly queries with preserveNullAndEmptyArrays when the foreign collection is empty and the strategy is Indexed Nested Loop

Closed

SERVER-119254 Update expected output of $lookup-unwind spilling golden test

Closed

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

Created:: Dec 01 2025 01:30:45 PM UTC
Updated:: Feb 25 2026 03:57:27 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates