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

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 7.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • ALL
    • 59
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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.

            Assignee:
            Hana Pearlman
            Reporter:
            Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: