Description
As of today the following meta query:
EXPLAIN SELECT meta().id FROM default WHERE ANY v IN b SATISFIES v.x > 10 END;
shows meta is covered if the particular array index has b also in it.
Array Index:
CREATE INDEX `ix` ON `default`((distinct (array (`v`.`x`) for `v` in `b` end)),b)
But meta should be covered whether or not b is part of ix array index or not.
i.e.
CREATE INDEX `iy` ON `default`((distinct (array (`v`.`x`) for `v` in `b` end)))
should also cover meta in above query.
Attachments
For Gerrit Dashboard: MB-18671 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
76347,2 | MB-22313: Test Panic when WHERE clause contains IN [ NULL ] MB-23372: Test gap in covering array indexes. MB-18671: Test N1QL: Array Indexing: meta with an array index should be covered inspite of the particular array field being present in the index | master | testrunner | Status: MERGED | +2 | +1 |
76348,2 | MB-22313: Test Panic when WHERE clause contains IN [ NULL ] MB-23372: Test gap in covering array indexes. MB-18671: Test N1QL: Array Indexing: meta with an array index should be covered inspite of the particular array field being present in the index | watson | testrunner | Status: MERGED | +2 | +1 |