[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:
Backports
Depends
is depended on by SERVER-72435 Add more targeted collation testing f... Closed
Problem/Incident
is caused by SERVER-61260 Support collations on clustered colle... Closed
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: SERVER-72224 Differentiate between 'simple' and non-simple collations for clustered collections

(cherry-picked from commit 03f7b6c2820e38d0a5b2084a1751e28b09789895)
Branch: v6.3
https://github.com/mongodb/mongo/commit/e911b1f41ce4a6cf9303fd12f8ca9ed345898948

Comment by Githook User [ 16/Mar/23 ]

Author:

{'name': 'Haley Connelly', 'email': 'haley.connelly@mongodb.com', 'username': 'haleyConnelly'}

Message: SERVER-72224 Differentiate between 'simple' and non-simple collations for clustered collections

(cherry-picked from commit 03f7b6c2820e38d0a5b2084a1751e28b09789895)
Branch: v6.0
https://github.com/mongodb/mongo/commit/910a79217e3a8d4ffa6270ba7d82b8ff5e82315b

Comment by Githook User [ 27/Feb/23 ]

Author:

{'name': 'Haley Connelly', 'email': 'haley.connelly@mongodb.com', 'username': 'haleyConnelly'}

Message: SERVER-72224 Differentiate between 'simple' and non-simple collations for clustered collections
Branch: master
https://github.com/mongodb/mongo/commit/03f7b6c2820e38d0a5b2084a1751e28b09789895

Generated at Thu Feb 08 06:21:10 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.