[SERVER-70691] Equality-indexed field cannot use $in in aggregation. Created: 19/Oct/22 Updated: 05/Dec/22 Resolved: 31/Oct/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Davis Haupt (Inactive) | Assignee: | Backlog - Query Optimization |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
|||||||||||||||||||
| Assigned Teams: |
Query Optimization
|
|||||||||||||||||||
| Operating System: | ALL | |||||||||||||||||||
| Steps To Reproduce: | Schema:
Query:
|
|||||||||||||||||||
| Sprint: | QO 2022-10-31 | |||||||||||||||||||
| Participants: | ||||||||||||||||||||
| Description |
|
Query analysis seems overly eager and errors when $in is used, even with an equality index, failing with the error: "ExpressionIn with RangeIndex not yet supported". The range intender should check if the field being operated on is indexed with range before asserting. |