-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
In SERVER-83524, we enabled the constant optimization for ExpressionFieldPath referencing a system variable ($$NOW, $$CLUSTER_TIME and $$USER_ROLES). This allowed for queries referencing a variable to use an index. We had to disable this optimization when featureFlagSbeFull is enabled because otherwise an incorrect value of the system variable may get embedded into the cached plan, as was the case in SERVER-74264.
This ticket tracks work to design and implement a solution that would allow SBE plan cache to handle this case.
- is related to
-
SERVER-83524 Enable indexed plans for expressions with $$NOW, $$CLUSTER_TIME, and $$USER_ROLES
- Closed