[SERVER-71093] Support $in range rewrites when querying on prefix of an encrypted field Created: 04/Nov/22  Updated: 05/Dec/22

Status: Open
Project: Core Server
Component/s: Queryable Encryption
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Ted Tuckman Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Sprint: QO 2022-11-14, QO 2022-11-28
Participants:

 Description   

If the field nested.age is encrypted, we can support queries of the form

{nested: {$in: [{age: 23, unencrypted: XYZ}, {age: 34, unencrypted: ABC}]}}

By rewriting to $or of multiple $and/$eq.

Work for this will need to be replicated for both match and agg.



 Comments   
Comment by Davis Haupt (Inactive) [ 08/Nov/22 ]

Moved out of PM-2470 because users can rewrite these queries by hand before running query analysis.

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