-
Type: Task
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
SPM-1930 will permit sharding with collation.
Queries which specify (a superset of) the shard key in equalities (e.g., sharded on {a:1}, query of {a:"foobar"}) can normally be targeted to a single shard. However, if the query collation does not match the sharding collation, this is not possible.
Prior to the fix for SERVER-94315 QueryPlannerParams::fillOutPlannerParamsForExpressQuery erroneously cleared INCLUDE_SHARD_FILTER in this case, leading to a query executing on multiple nodes, but with no shard filtering, leading to potential duplicate results from orphans.
At the time of SERVER-94315, prior to SPM-1930, the only possible sharding collation was simple. Once SPM-1930 changes this, QueryPlannerParams::fillOutPlannerParamsForExpressQuery must be updated to reflect this.
- is related to
-
SERVER-94315 Shard filtering bug with collation
- Closed