[SERVER-70319] [FLE] Equality queries on range indexes inside an $and error Created: 06/Oct/22  Updated: 29/Oct/23  Resolved: 19/Oct/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Gil Alon Assignee: Davis Haupt (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: QO 2022-10-31
Participants:

 Description   

The query below raises an error that equality queries should only be run with equality indexes. However, we want to be able to run equality queries on range indexes as well. This query can be found in the enterprise modules under fle2/query/find_range.js

{$and: [
{salary: {$gt: Number(10020)}},
{savings: {$eq: NumberLong(1230500)}}
]}, 



 Comments   
Comment by Githook User [ 19/Oct/22 ]

Author:

{'name': 'Davis Haupt', 'email': 'davis.haupt@mongodb.com', 'username': 'davish'}

Message: SERVER-70319 support encrypted $eq with range index under $and
Branch: master
https://github.com/10gen/mongo-enterprise-modules/commit/b41b3f300c151996e44fd1d3118f1b7c9ef16b82

Generated at Thu Feb 08 06:15:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.