[SERVER-83563] Extend logic for recognizing used optimizer Created: 23/Nov/23  Updated: 02/Dec/23  Resolved: 02/Dec/23

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

Type: Bug Priority: Major - P3
Reporter: Matt Olma Assignee: Matt Olma
Resolution: Fixed Votes: 0
Labels: auto-reverted
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Fix
Problem/Incident
Backwards Compatibility: Fully Compatible
Operating System: ALL
Steps To Reproduce:

buildscripts/resmoke.py run -suites=causally_consistent_hedged_reads_jscore_passthrough --continueOnFailure --excludeWithAnyTags=requires_ocsp_stapling,requires_increased_memlock_limits,requires_sbe --jobs=6 --shuffle '-mongodSetParameters={internalQueryFrameworkControl: forceClassicEngine}' --storageEngineCacheSizeGB=1 jstests/core/query/agg_hint.js

Participants:
Linked BF Score: 161

 Description   

Depending on query and existing failpoints the system may use either classic planner or CQF optimizer. JS tests which assert on explain outputs need to recognize which optimizer has been used to assert correctly.

The explain helper "usedBonsaiOptimizer" helps with this, however it does not cover all cases. This ticket ensures that the helper treats correctly all explain outputs.



 Comments   
Comment by Githook User [ 30/Nov/23 ]

Author:

{'name': 'Matt Olma', 'email': 'matt.olma@mongodb.com', 'username': 'mattsimply'}

Message: SERVER-83563: Extend logic for recognizing used optimizer
Branch: master
https://github.com/mongodb/mongo/commit/ad9cbcbd626d7eadf60f91b756f76b2b7fde8778

Comment by Githook User [ 29/Nov/23 ]

Author:

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

Message: Revert "SERVER-83563: Extend logic for recognizing used optimizer"

This reverts commit 0fe43bd03e09389277b563447670c9b9318bb25c.
Branch: master
https://github.com/mongodb/mongo/commit/0f1e49a4b8335c077e8b5163161e21b650157b54

Comment by Githook User [ 28/Nov/23 ]

Author:

{'name': 'Matt Olma', 'email': 'matt.olma@mongodb.com', 'username': 'mattsimply'}

Message: SERVER-83563: Extend logic for recognizing used optimizer
Branch: master
https://github.com/mongodb/mongo/commit/0fe43bd03e09389277b563447670c9b9318bb25c

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