-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
Fully Compatible
-
QO 2023-09-18
Currently, this test is skipped when the query knob internalQueryPlanTieBreakingWithIndexHeuristics is on (which is by default), as it fails due to multi-planner tie breaking choosing a plan with CLUSTERED_IXSCAN over FETCH.
Specifically, the following cases fail:
"findAndModify remove with positional projection with sort" "findAndModify update with positional projection with sort" "findAndModify update with positional update with sort"
SERVER-80386 will resolve this failure, so one option is to just re-enable this test when it is closed.
Another option is to specifically address the failing cases without refactoring the entire test. Then, the test could also be re-enabled.
The third option is to change multi-planner tie breaking so that the totalDocsExamined heuristic is only applied when plans do not reach EOF in the trial run. This means that this test will no longer be affected and hence can be re-enabled.
- related to
-
SERVER-80386 Refactor jstests/sharding/updateOne_without_shard_key/explain.js
- Closed