SBE multi-planning can incorrectly favor a blocking SORT plan over a non-blocking plan

XMLWordPrintableJSON

    • Fully Compatible
    • ALL
    • Query Execution 2021-06-28, Query Execution 2021-07-12, Query Execution 2021-07-26
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Rerunning the famous Eliot's chess query game-search-test.js (github.com)

      shows different winning plans are selected.

       

      We have to understand what is going on

              Assignee:
              David Storch
              Reporter:
              Martin Neupauer (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: