[SERVER-75149] Simplify BSON produced by $lookup for foreign field local field join Created: 22/Mar/23 Updated: 29/Oct/23 Resolved: 24/Mar/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.0.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Matt Boros | Assignee: | Matt Boros |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| Backwards Compatibility: | Fully Compatible | ||||
| Sprint: | QO 2023-04-03 | ||||
| Participants: | |||||
| Description |
|
$lookup wraps its $match join in an $and when there is potentially one predicate, with potentially empty predicates included. Since we re-optimize and canonicalize the pipeline for every outer document, it's best for us to produce simpler BSON if possible in $lookup. |
| Comments |
| Comment by Githook User [ 23/Mar/23 ] |
|
Author: {'name': 'Matt Boros', 'email': 'matt.boros@mongodb.com', 'username': 'mattBoros'}Message: |