Rewrite equality predicate for encrypted to range predicate when there is only a range index

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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:
              [DO NOT USE] Backlog - Query Optimization
              Reporter:
              Davis Haupt (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: