-
Type:
Task
-
Resolution: Fixed
-
Priority:
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}}]}
- depends on
-
SERVER-67210 Generate placeholders for open range predicates in MatchExpressions
-
- Closed
-
- is duplicated by
-
SERVER-68272 Rewrite equality predicate for encrypted to range predicate when there is only a range index
-
- Closed
-