Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0, 6.6.1
-
Untriaged
-
1
-
Yes
Description
create primary index on default;
create index ix1 on default(c1) where meta().id like "abc%";
create index ix2 on default(c2) where meta().id like "abc%";
create index ix3 on default(c3) where meta().id like "abc%";
explain select * from default where meta().id like "abc%" and (c1 = 1 or c2 = 2 or c3 = 3);
in 6.0 a union scan with ix1/ix2/ix3 is used, in 6.6.0 and later primary index scan is used.
Attachments
Issue Links
- is a backport of
-
MB-45272 Primary index scan used with query with OR condition
- Closed