Description
CREATE INDEX ix1 ON default( DISTINCT a1, c1);
EXPLAIN SELECT META().id FROM default WHERE ANY v IN a1 SATISFIES v = 5 END AND (c1 =15 OR c1 = 20); is not covered
If there is no OR clause it is covered.
Attachments
For Gerrit Dashboard: MB-28662 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
92069,2 | MB-28662 Array index and OR clause may not cover the query properly | master | query | Status: MERGED | +2 | +1 |