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

Rewrite encrypted equality query to range query when only range index exists

XMLWordPrintableJSON

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • QO 2022-09-05

      If an encrypted field has both an equality index and a range index, the equality index will be used as before to answer equality queries. If an encrypted field only has a range index, however, query analysis should rewrite the query to correctly return results without an equality index.

      {x: {$eq: 26}}
      will be rewritten to
      {$and: [{x: {$gte: 26}}, {x: {$lte: 26}}]}

            Assignee:
            ted.tuckman@mongodb.com Ted Tuckman
            Reporter:
            davis.haupt@mongodb.com Davis Haupt (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: