[SERVER-36994] $expr does not use index for $in Created: 05/Sep/18 Updated: 05/Sep/18 Resolved: 05/Sep/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Aggregation Framework |
| Affects Version/s: | 3.6.7, 4.0.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Mathias C. | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||||||||
| Steps To Reproduce: | Create a new collection. Create index :
Insert data :
Query :
Wining Plan
|
||||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||||
| Description |
|
An $expr expression in a query will not use an index when used with $in. The goal was to used it in a $lookup pipeline. The problem seems to exists in 3.6.3 as well as 4.0.2 |
| Comments |
| Comment by James Wahlin [ 05/Sep/18 ] |
|
Hi Mathias, This issue is currently being tracked by SERVER-32549. Please follow that ticket for updates and feel free to vote and/or add comments. Best, James |