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

Clustered collections with non-"simple" default collation miss documents when querying on _id using "simple" collation

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.0.0-rc0, 6.0.6, 6.3.2
    • Affects Version/s: 6.0.0, 6.1.0, 6.2.0-rc4
    • Component/s: Query Planning
    • None
    • Storage Execution
    • Fully Compatible
    • ALL
    • v6.3, v6.0
    • Execution Team 2023-02-20, Execution Team 2023-03-06

      When a clustered collection has a non-"simple" default collation, its _id values are encoded using the collection's default collation. This means the minRecord and maxRecord bounds cannot be constrained when querying by _id and using a collation differing from the collection's default. However, handleRIDRangeScan() incorrectly always permits tighter bounds when using {locale: "simple"}.

            Assignee:
            haley.connelly@mongodb.com Haley Connelly
            Reporter:
            max.hirschhorn@mongodb.com Max Hirschhorn
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: