[SERVER-51718] Disallow sparse, hashed indexes from being considered for answering $exists: false queries. Created: 16/Oct/20 Updated: 29/Oct/23 Resolved: 04/Nov/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 4.9.0, 4.4.3 |
| Type: | Bug | Priority: | Critical - P2 |
| Reporter: | Sam Mercier | Assignee: | James Wahlin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||
| Operating System: | ALL | ||||||||||||||||
| Backport Requested: |
v4.4
|
||||||||||||||||
| Sprint: | Query 2020-10-19, Query 2020-11-02, Query 2020-11-16 | ||||||||||||||||
| Participants: | |||||||||||||||||
| Linked BF Score: | 9 | ||||||||||||||||
| Description |
|
The index selector currently believes that hashed, sparse indexes can be used to answer {$exists:false} queries. However, sparse indexes cannot be used to answer such queries so this triggers a failure. A resolution to this ticket would include: |
| Comments |
| Comment by Githook User [ 23/Nov/20 ] |
|
Author: {'name': 'James Wahlin', 'email': 'james@mongodb.com', 'username': 'jameswahlin'}Message: (cherry picked from commit daa74ba2f414534e736f408b40d62aef869b06cc) |
| Comment by Githook User [ 04/Nov/20 ] |
|
Author: {'name': 'James Wahlin', 'email': 'james@mongodb.com', 'username': 'jameswahlin'}Message: |