Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 8.1.0-rc0, 7.0.22, 8.0.12
Affects Version/s: None
Component/s: None
Labels:
- auto-reverted

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
Operating System:
ALL
Backport Requested:

v8.0, v7.0
Linked BF Score:
200
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

On v8.0 (and probably the master branch too), even though the SBE plan cache is not reachable, we may still parameterize and generate IETs for queries. This is wasted work.

causes

SERVER-101839 Set taggedMatchExpressionHash in QueryPlanner::planFromCache

Closed

is depended on by

SERVER-97776 Do not parameterize CanonicalQueries for SBE plan cache when featureFlagSbeFull is off

Backlog

SERVER-97778 Remove IETs

Backlog

is related to

SERVER-96805 Investigate why wildcard index candidate plans are non-deterministic

Closed

related to

SERVER-97685 Planner can fail to generate IETs when SBE plan cache is enabled

Backlog

SERVER-105903 [v7.0] Duplicate equality predicate prevents index suffix from satisfying sort

Closed

SERVER-101922 Indices in MatchExpressions should be cached in a position-independent manner

Closed

(2 related to)

Assignee:: Henri Nikku
Reporter:: Hana Pearlman
Participants:: Githook User, Hana Pearlman, Henri Nikku
Votes:: 0 Vote for this issue
Watchers:: 13 Start watching this issue

Created:: Nov 26 2024 07:40:32 PM UTC
Updated:: Jul 16 2025 03:37:44 PM UTC
Resolved:: Feb 28 2025 01:54:34 PM UTC
Confidence Status Last Update:: 28/Nov/24 11:11 AM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates