[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
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. |