Details
-
Bug
-
Resolution: Fixed
-
Major - P3
-
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.