[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). |
| 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 |