Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 8.3.0-rc0, 8.2.2, 8.0.18, 7.0.31
Affects Version/s: 8.2.1, 7.0.26, 8.0.16
Component/s: None
Labels:

Assigned Teams:

Catalog and Routing
Backwards Compatibility:
Fully Compatible
Operating System:
ALL
Backport Requested:

v8.2, v8.0, v7.0
Sprint:
CAR Team 2025-09-01, CAR Team 2025-09-15, CAR Team 2025-09-29
CAR Domain/s:

🟥 DDL

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

Some compound wildcard indexes can be used as the shard key index, when this is not supported and can lead to severe correctness issues. We should add validation to prevent this.

In the repro attached, we see that when a collection is sharded and the shard key index has a wildcard component, documents can be missed in a full collection scan plan.

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List
  - Download All

repro_with_compound_wildcard_index_in_ascending_order.js
1 kB
Feb 10 2026 04:36:49 PM UTC
repro_with_compound_wildcard_index_in_descending_order.js
2 kB
Feb 10 2026 04:36:49 PM UTC

is related to

SERVER-109929 shardCollection/reshardCollection must attempt to create a shardkey when a multikey/wildcard index exists on the shard key field

Closed

SERVER-110953 Check no orphaned document is present on a recipient shard before starting cloning a range

Closed

related to

SERVER-112358 [v7.0] Resharding doesn't create a shard key index if a multikey index exists prefixed by the shard key

Backlog

SERVER-89308 Create query property tester

Closed

SERVER-112793 Remove metrics for compound wildcard index prefixed by shard key once 9.0 branches out

Backlog

SERVER-109796 Investigate shardKeyIndex scan incorrect behavior with a compound wildcard index

Closed

SERVER-109946 IndexDescriptor::isSparse should return true for wildcard indexes

Closed

SERVER-112792 Report existance of compound wildcard indexes prefixed by the shard key

Closed

(3 related to)

Assignee:: Silvia Surroca
Reporter:: Matt Boros
Participants:: Githook User, Matt Boros, Silvia Surroca
Votes:: 0 Vote for this issue
Watchers:: 26 Start watching this issue

Created:: Apr 14 2025 03:20:42 PM UTC
Updated:: Feb 10 2026 07:29:58 PM UTC
Resolved:: Sep 22 2025 05:44:42 PM UTC

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates