Vary types of params under the “any” field in plan cache fuzzer

XMLWordPrintableJSON

    • 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.

            Assignee:
            Unassigned
            Reporter:
            Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: