[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:
Backports
Depends
Documented
is documented by DOCS-11691 Docs for SERVER-34851: Disallow index... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v3.6, v3.4, v3.2
Sprint: Query 2018-05-21
Participants:
Case:
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: SERVER-34851 Disallow index selection for identical min & max values on find

(cherry picked from commit 737596d7005ae061809cbd8483ba91b4a2a89d86)
(cherry picked from commit dc67135fd82a254faabd8e2a32ac6624d3135655)
(cherry picked from commit bf5eb1a3278ca3e23bac00e10077e97607cc0b67)
Branch: v3.2
https://github.com/mongodb/mongo/commit/a3210c8e070ca82907415c111b0919a82210362c

Comment by Githook User [ 22/May/18 ]

Author:

{'username': 'jameswahlin', 'name': 'James Wahlin', 'email': 'james@mongodb.com'}

Message: SERVER-34851 Disallow index selection for identical min & max values on find

(cherry picked from commit 737596d7005ae061809cbd8483ba91b4a2a89d86)
(cherry picked from commit dc67135fd82a254faabd8e2a32ac6624d3135655)
Branch: v3.4
https://github.com/mongodb/mongo/commit/bf5eb1a3278ca3e23bac00e10077e97607cc0b67

Comment by Githook User [ 22/May/18 ]

Author:

{'username': 'jameswahlin', 'name': 'James Wahlin', 'email': 'james@mongodb.com'}

Message: SERVER-34851 Disallow index selection for identical min & max values on find

(cherry picked from commit 737596d7005ae061809cbd8483ba91b4a2a89d86)
Branch: v3.6
https://github.com/mongodb/mongo/commit/dc67135fd82a254faabd8e2a32ac6624d3135655

Comment by Githook User [ 11/May/18 ]

Author:

{'name': 'James Wahlin', 'email': 'james@mongodb.com', 'username': 'jameswahlin'}

Message: SERVER-34851 Disallow index selection for identical min & max values on find
Branch: master
https://github.com/mongodb/mongo/commit/737596d7005ae061809cbd8483ba91b4a2a89d86

Generated at Thu Feb 08 04:38:04 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.