[SERVER-62689] Support index on _id with different collation for clustered collections Created: 17/Jan/22  Updated: 22/May/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Daniel Gomez Ferro Assignee: Backlog - Storage Execution Team
Resolution: Unresolved Votes: 0
Labels: clustered_collections
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-62688 Verify clustered collections with col... Closed
Assigned Teams:
Storage Execution
Participants:

 Description   

SERVER-61260 added support for collations to clustered collections. Sharding requires an index with collation = simple on the shard key, if we want to shard on _id we'd need to create an explicit index on _id with the simple collation, but currently that's not possible:

Some of these restrictions were introduced by SERVER-26724 to protect _id index creation when using autoIndexId: false, which is no longer supported. I think it should be OK to relax some of these restrictions, at the very least for clustered collections.


Generated at Thu Feb 08 05:55:48 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.