Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-94718

Create a property-based test to assert that all plan rejected plans return the same results as the winning plan

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution

      This property test could take a randomly generated query, run explain to look at the winning and rejected plans, and then run every plan to assert the results are all the same.

      There may be some plans we consider that are never run in our jstests because the data in the collection isn't the right distribution. It would be hard to find these issues without forcing each plan to run and asserting on the results. This is an area where PBT excels.

            Assignee:
            matt.boros@mongodb.com Matt Boros
            Reporter:
            matt.boros@mongodb.com Matt Boros
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: