[SERVER-83220] Lookup between unsplittable collections gets incorrectly pushed down to SBE Created: 14/Nov/23 Updated: 06/Feb/24 Resolved: 06/Feb/24 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 8.0.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ivan Fefer | Assignee: | Mihai Andrei |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | auto-reverted | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Query Execution
|
| Backwards Compatibility: | Fully Compatible |
| Sprint: | QE 2023-12-11, QE 2023-12-25, QE 2024-01-08, QE 2024-01-22, QE 2024-02-05, QE 2024-02-19 |
| Participants: |
| Description |
|
Currently, SBE doesn't support remote reads, so we check that all involved collections are unsharded, before we do $lookup in SBE: We need to check for data colocation instead. |
| Comments |
| Comment by Githook User [ 05/Feb/24 ] |
|
Author: {'name': 'Mihai Andrei', 'email': 'mihai.andrei@mongodb.com', 'username': 'mtandrei'}Message: Co-authored-by: Jordi Serra Torrens <jordi.serra-torrens@mongodb.com> |
| Comment by Githook User [ 03/Feb/24 ] |
|
Author: {'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}Message: Revert " This reverts commit a63db2a047e3b654820ac085a1207488b6418cd2. GitOrigin-RevId: b67c20a8ac78de07743fa5df6cea83057ae92034 |
| Comment by Githook User [ 03/Feb/24 ] |
|
Author: {'name': 'Mihai Andrei', 'email': 'mihai.andrei@mongodb.com', 'username': 'mtandrei'}Message: Co-authored-by: Jordi Serra Torrens <jordi.serra-torrens@mongodb.com> |
| Comment by Ivan Fefer [ 20/Nov/23 ] |
|
Good thing is that both isMainCollectionSharded and collections.isAnySecondaryNamespaceAViewOrSharded() are only used here, so we can remove this in favor of something like areAllNamespacesColocated() or something like that. We need to change this code in db RAII:
|