Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0
-
Untriaged
-
Yes
Description
Create default bucket
Insert docs like the following:
{a:100, d:200}
create 4 indexes:
create index idx1 on default(a, d);
create index idx2 on default(a, b, d);
create index idx3 on default(a, b, c, d);
create index idx4 on default(a, b, c, d, e);
run queries:
select * from default where a > 0 and d > 0;
select a, d from default where a > 0 and d > 0;
In both cases idx3 will be selected which results in unnecessary extra work