-
Type: Bug
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: 7.2.0, 7.3.0, 8.1.0-rc0, 8.0.0-rc9
-
Component/s: None
-
None
-
Catalog and Routing
-
ALL
-
v8.0
-
CAR Team 2024-08-05
When creating an index with simple collation, the simple collation is removed from the index spec here. Then, the normalization added by SERVER-81890 here will add the collection's default collation to the index spec.
This means that when building an index with a simple collation, this index spec will compare as equal to one with the collection's default collator and so no new index will be created if there is already an index on the same key with the collection's default collation.
This also has the side effect of causing us not to create a shard key index in some circumstances since the shard key index must have simple collation. So if an index already exists on the shard key with the default collation, we will end up with a sharded collection missing the shard key index.
- is caused by
-
SERVER-81890 Avoid invariant due to in progress index build during initial sync
- Closed
- is fixed by
-
SERVER-93112 Revert SERVER-81890 due to index spec collation overnormalization
- Closed
- related to
-
SERVER-92967 Refactor index spec collations to be a proper type
- Backlog