[SERVER-34851] Disallow index selection for identical min & max values on find Created: 04/May/18 Updated: 29/Oct/23 Resolved: 11/May/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 3.2.19, 3.4.14, 3.6.4, 3.7.9 |
| Fix Version/s: | 3.2.21, 3.4.16, 3.6.6, 4.0.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | James Wahlin | 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: |
v3.6, v3.4, v3.2
|
||||||||||||||||
| Sprint: | Query 2018-05-21 | ||||||||||||||||
| Participants: | |||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||
| Linked BF Score: | 45 | ||||||||||||||||
| Description |
|
As the max value is an exclusive bound, setting min and max to the same value will match nothing, even when an index exists that supports the key provided. |
| Comments |
| Comment by Githook User [ 22/May/18 ] |
|
Author: {'username': 'jameswahlin', 'name': 'James Wahlin', 'email': 'james@mongodb.com'}Message: (cherry picked from commit 737596d7005ae061809cbd8483ba91b4a2a89d86) |
| Comment by Githook User [ 22/May/18 ] |
|
Author: {'username': 'jameswahlin', 'name': 'James Wahlin', 'email': 'james@mongodb.com'}Message: (cherry picked from commit 737596d7005ae061809cbd8483ba91b4a2a89d86) |
| Comment by Githook User [ 22/May/18 ] |
|
Author: {'username': 'jameswahlin', 'name': 'James Wahlin', 'email': 'james@mongodb.com'}Message: (cherry picked from commit 737596d7005ae061809cbd8483ba91b4a2a89d86) |
| Comment by Githook User [ 11/May/18 ] |
|
Author: {'name': 'James Wahlin', 'email': 'james@mongodb.com', 'username': 'jameswahlin'}Message: |