[SERVER-83839] Implement query-knob guarded logic to skip Sargable rewrites Created: 04/Dec/23  Updated: 14/Dec/23  Resolved: 14/Dec/23

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: Alya Berciu Assignee: Alya Berciu
Resolution: Fixed Votes: 0
Labels: M7
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-81973 Implement generic logic to configure ... Closed
is depended on by SERVER-83927 Investigate/fix memory error with opt... Open
is depended on by SERVER-83442 Reorder predicates in a Filter node b... Backlog
is depended on by SERVER-83456 Skip Filter->Sargable rewrite for col... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-12-11, QO 2023-12-25
Participants:

 Description   

This should include:

  • a query knob
  • logic to identify when to skip rewrites/ pick the appropriate phases/rewrites
  • an alternate rewrite to replace FilterSubstitute where we don't generate SargableNodes
  • avoid splitting filter nodes if we are not generating sargable nodes


 Comments   
Comment by Githook User [ 13/Dec/23 ]

Author:

{'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}

Message: SERVER-83839 Implement query-knob guarded logic to skip Sargable rewrites

GitOrigin-RevId: c1532914e310065715b9bc7604f1a7831d304577
Branch: master
https://github.com/mongodb/mongo/commit/e3f5149450f3604c8cb53416e0370422f40f1eb7

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