[SERVER-65153] Duplicated results when INLJ is used for $lookup in SBE Created: 31/Mar/22 Updated: 29/Oct/23 Resolved: 04/Apr/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.0.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Irina Yatsenko (Inactive) | Assignee: | Nikita Lapkov (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Backwards Compatibility: | Fully Compatible |
| Operating System: | ALL |
| Sprint: | QE 2022-04-04, QE 2022-04-18 |
| Participants: |
| Description |
|
no indexes on the foreign collection "r", NLJ is used: , { "_id" : 11, "a" : [ 2, 1 ] } ] db.r.createIndex( {a:1}) // this enables INLJ strategy for the lookup , { "_id" : 11, "a" : [ 2, 1 ] }, { "_id" : 2, "a" : [ 1, 2 ], "y" : 3 }, { "_id" : 11, "a" : [ 2, 1 ] }] } |
| Comments |
| Comment by Githook User [ 01/Apr/22 ] |
|
Author: {'name': 'Nikita Lapkov', 'email': 'nikita.lapkov@mongodb.com', 'username': 'laplab'}Message: |