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

XMLWordPrintableJSON

    • Query Optimization
    • Fully Compatible
    • 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:
            Kartal Kaan Bozdogan
            Reporter:
            Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: