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

Track indexOptions in QueryTester

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 8.1.0-rc0
    • Affects Version/s: None
    • Component/s: QueryTester
    • None
    • Query Optimization
    • Fully Compatible
    • ALL
    • QO 2024-11-25
    • 200

      Queries that pass in jstestfuzz rely on indices with indexOptions, whereas QueryTester doesn't take indexOptions into account. Even though the index used in a winning plan may not have any indexOptions, the plans considered during multiplanning may include indices with indexOptions. Those indices, along with their indexOptions, may not be considered during multiplanning (or may have different underlying eligibility logic), whereas without indexOptions, they may be considered and thus fail for the query in the multiplanning phase.

      To ensure that all tests that pass in the fuzzer also pass in QueryTester, we should take into account indexOptions in QueryTester .coll files.

            Assignee:
            lynne.wang@mongodb.com Lynne Wang
            Reporter:
            lynne.wang@mongodb.com Lynne Wang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: