[SERVER-44328] multikeys Index unbounded with $elemMatch Created: 30/Oct/19 Updated: 27/Oct/23 Resolved: 31/Oct/19 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | FRANCK LEFEBURE | Assignee: | Unassigned |
| Resolution: | Works as Designed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Operating System: | ALL |
| Participants: |
| Description |
|
I found many closed issues about multikeys index bounds but I can't find an opened one for the 3.6.13 Regarding this index :
And this query :
Then the query planner uses the previous index with theses bounds :
==> OK Now with this query variant
Then the bounds are :
=> timeout..
|
| Comments |
| Comment by Carl Champain (Inactive) [ 31/Oct/19 ] | |
|
No problem, and thanks anyway for the report. I'm glad our documentation was useful! Kind regards, | |
| Comment by FRANCK LEFEBURE [ 31/Oct/19 ] | |
|
OMG I just see this https://docs.mongodb.com/manual/core/multikey-index-bounds/ section :
{{}} So it's documented. Sorry for the noise |