-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
The existing plan cache fuzzer generates multiple queries of the same shape however it does not appear to vary the types of parameters. A sequence of queries with the same query shape but different types of parameters is historically a problem scenario for the plan cache, and we should be testing it in the fuzzer.
We intended to include this work in DEVPROD-2804, which was an action item for a CA. However, as part of that ticket, we discovered that the plan cache fuzzer was not working as intended (see SERVER-110255).
After SERVER-110255 is completed, this ticket should be a fast follow.
- is related to
-
SERVER-110255 Generate the same query shape with different constants in the plan cache fuzzer (again)
-
- Closed
-