Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-55790

Ensure query rewrites for time-series collections are correct in the case of mismatched collations

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 5.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • Query Optimization 2021-04-19, Query Optimization 2021-05-03

      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.

            Assignee:
            katherine.wu@mongodb.com Katherine Wu (Inactive)
            Reporter:
            katherine.wu@mongodb.com Katherine Wu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: