Investigate and create tests for cases where $in chooses sub optimal plan

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • ALL
    • QE 2024-03-04
    • 1
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      HELP-52858 highlights a case where a $in query chooses a sub optimal index to execute the query when using the sbe multiplanner. We should try to repro this issue and have a test case for this.

            Assignee:
            Adi Agrawal (Inactive)
            Reporter:
            Adi Agrawal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: