[SERVER-55790] Ensure query rewrites for time-series collections are correct in the case of mismatched collations Created: 05/Apr/21  Updated: 29/Oct/23  Resolved: 30/Apr/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.0.0-rc0

Type: Task Priority: Major - P3
Reporter: Katherine Wu (Inactive) Assignee: Katherine Wu (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-55653 Queries on time-series views do not a... Closed
Related
related to SERVER-54597 Allow users to specify non-default co... Closed
is related to SERVER-56264 Investigate if reads on time-series c... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query Optimization 2021-04-19, Query Optimization 2021-05-03
Participants:

 Description   

Sharding support for time-series collections requires using an index with simple collation. Currently queries on a view must use the same collation as the view's default collation, however after SERVER-55653 queries on time-series collections will also be able to specify a simple collation (even if the default collation is not simple) to allow for sharded time-series collections. We must make sure that our query rewrites (ie. predicate mapping to the buckets' control.min/max fields, pushing meta predicates past $_internalUnpackBucket) will return correct results in the event that the query's collation is simple and does not match the default collection collation.

Note that the optimization work for this ensures for correct rewrites for any specified collation, not just the simple collation.



 Comments   
Comment by Githook User [ 30/Apr/21 ]

Author:

{'name': 'Katherine Wu', 'email': 'katherine.wu@mongodb.com', 'username': 'kaywux'}

Message: SERVER-55790 Ensure query rewrites for time-series collections are correct in the case of mismatched collations
Branch: master
https://github.com/mongodb/mongo/commit/6f026d8a741553b49177ae1fdfd8c0e967baa2d8

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