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

Fix ord.js so it ensures an ixscan plan is used

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 7.1.0-rc0
    • None
    • None
    • None
    • Fully Compatible
    • ALL
    • 59

    Description

      The ord.js file tests that "dropping indexes required by an indexed $or causes the query to fail cleanly". But, with CQF, we may choose a collscan for the query, since neither of the predicates are particularly selective.

      This test relies on the query optimizer choosing an ixscan plan, so it should hint an index or make the predicates more selective to ensure this is true.

      Note that this only affects CQF M4.

      Attachments

        Activity

          People

            hana.pearlman@mongodb.com Hana Pearlman
            hana.pearlman@mongodb.com Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: