[SERVER-72224] Clustered collections with non-"simple" default collation miss documents when querying on _id using "simple" collation Created: 16/Dec/22 Updated: 29/Oct/23 Resolved: 27/Feb/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Query Planning |
| Affects Version/s: | 6.0.0, 6.1.0, 6.2.0-rc4 |
| Fix Version/s: | 7.0.0-rc0, 6.0.6, 6.3.2 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Max Hirschhorn | Assignee: | Haley Connelly |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||
| Assigned Teams: |
Storage Execution
|
||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||
| Backport Requested: |
v6.3, v6.0
|
||||||||||||||||||||
| Sprint: | Execution Team 2023-02-20, Execution Team 2023-03-06 | ||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Description |
|
When a clustered collection has a non-"simple" default collation, its _id values are encoded using the collection's default collation. This means the minRecord and maxRecord bounds cannot be constrained when querying by _id and using a collation differing from the collection's default. However, handleRIDRangeScan() incorrectly always permits tighter bounds when using {locale: "simple"}. |
| Comments |
| Comment by Githook User [ 18/Apr/23 ] |
|
Author: {'name': 'Haley Connelly', 'email': 'haley.connelly@mongodb.com', 'username': 'haleyConnelly'}Message: (cherry-picked from commit 03f7b6c2820e38d0a5b2084a1751e28b09789895) |
| Comment by Githook User [ 16/Mar/23 ] |
|
Author: {'name': 'Haley Connelly', 'email': 'haley.connelly@mongodb.com', 'username': 'haleyConnelly'}Message: (cherry-picked from commit 03f7b6c2820e38d0a5b2084a1751e28b09789895) |
| Comment by Githook User [ 27/Feb/23 ] |
|
Author: {'name': 'Haley Connelly', 'email': 'haley.connelly@mongodb.com', 'username': 'haleyConnelly'}Message: |