Operational Defect Database
BugZero found this defect 46 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
MongoDB | 2631442
Skip query settings application on queries containing min/max fields.
Last update date:
4/3/2024
Affected products:
MongoDB Server
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Info
Min/max queries require explicit index cursor hints. The presence of query settings will cause the planning system to ignore cursor hints, and throw an unnamed error code, different than NoQueryExecutionPlans. As the query settings fallback mechanism only works on NoQueryExecutionPlans errors, this min/max error will bypass the retry, making the query fail even if a cursor hint is present.
Top User Comments
max.hirschhorn@10gen.com commented on Wed, 3 Apr 2024 16:36:33 +0000: Min/max queries require explicit $natural cursor hints. The min and max parameters to the find command have required hinting an index since SERVER-39567 (4.2) but $natural wouldn't correspond to an index definition. Can the description here please be updated? Perhaps an example would further clarify the issue.
Steps to Reproduce
