Winning plan solutionHashUnstable is post-extension, fails for forcedPlanSolutionHash

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 9.1.0-rc0, 9.1.0-rc1023
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • Fully Compatible
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      For winning plans, explain solutionHashUnstable reports the hash of the solution after it may have been extended with a pushed down pipeline.

      However, when forcedPlanSolutionHash is used to force a plan, it must match the hash before extension.

      Fix by capturing the hash earlier.

      This is only necessary when the appropriate knob is enabled, allowing use of forcedPlanSolutionHash in tests.

            Assignee:
            James Harrison
            Reporter:
            James Harrison
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: