[SERVER-79233] Ensure query settings $natural hints are applied for the specified queries Created: 24/Jul/23  Updated: 23/Jan/24  Resolved: 23/Jan/24

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.3.0-rc0

Type: Task Priority: Major - P3
Reporter: Denis Grebennicov Assignee: Catalin Sumanaru
Resolution: Fixed Votes: 0
Labels: M2, auto-reverted
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-84047 Introduce cursor_hints_to_query_setti... Closed
Problem/Incident
Related
related to SERVER-41458 $natural hint overrides index filters Closed
is related to SERVER-84018 Mark slow queries affected by query s... Backlog
is related to SERVER-84020 Add query settings fallback reason fi... Backlog
is related to SERVER-85242 Ensure the robustness of the 'QuerySe... In Progress
is related to SERVER-85321 Centralize the COLLSCAN direction hin... Open
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-11-27, QE 2023-12-11, QE 2023-12-25, QE 2024-01-08, QE 2024-01-22, QE 2024-02-05
Participants:
Linked BF Score: 35

 Description   

$natural index hints are not supported in index filters, therefore the query planner mechanism needs to be adjusted, in order to ensure that $natural index hints are applied and influence the selected plan



 Comments   
Comment by Githook User [ 23/Jan/24 ]

Author:

{'name': 'Catalin Sumanaru', 'email': 'catalin.sumanaru@mongodb.com', 'username': 'csum112'}

Message: SERVER-79233 Ensure query settings $natural hints are applied for the specified queries (#18230)

GitOrigin-RevId: e9d44fda572a9eeeb547d7df8b9328e9ae7714cc
Branch: master
https://github.com/mongodb/mongo/commit/98338e7fc085de174d0074536c65001518de113e

Comment by Githook User [ 22/Jan/24 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-79233 Ensure query settings $natural hints are applied for the specified queries (#17197)"

This reverts commit 7e405b23fa7af7b2112815b479ccbcf0daa3539e.

GitOrigin-RevId: 05786ddb21554e894c31e6769678cd6847a149fe
Branch: master
https://github.com/mongodb/mongo/commit/1bd6850c5315b4083326129f68b2e73c99787b6f

Comment by Githook User [ 22/Jan/24 ]

Author:

{'name': 'Catalin Sumanaru', 'email': 'catalin.sumanaru@mongodb.com', 'username': 'csum112'}

Message: SERVER-79233 Ensure query settings $natural hints are applied for the specified queries (#17197)

GitOrigin-RevId: 7e405b23fa7af7b2112815b479ccbcf0daa3539e
Branch: master
https://github.com/mongodb/mongo/commit/0376d0cbc2294cf874cafdef9ef070e2bde0b07f

Generated at Thu Feb 08 06:40:25 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.