[SERVER-63700] Make sure $lookup, lowered to NLJ in SBE, has proper semantics for empty arrays Created: 15/Feb/22  Updated: 29/Oct/23  Resolved: 22/Mar/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.0.0-rc0

Type: Task Priority: Major - P3
Reporter: Irina Yatsenko (Inactive) Assignee: Irina Yatsenko (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Sprint: QE 2022-04-04, QE 2022-03-07, QE 2022-03-21
Participants:

 Description   

The current implementation of $lookup via NLJ in SBE doesn't match the semantics in the classic engine (that is, it doesn't match terminal empty arrays to null/missing/undefined). SERVER-63368 tracks whether we'd like to change the classic semantics.



 Comments   
Comment by Irina Yatsenko (Inactive) [ 22/Mar/22 ]

Fixed by https://github.com/10gen/mongo/pull/4049, that was merged as https://github.com/mongodb/mongo/commit/a50de54ad246afc5b85720b28e7e89720b4a1d6c

Generated at Thu Feb 08 05:58:25 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.