Details
Description
CREATE INDEX ix1 ON default(type);
CREATE PRIMARY INDEX ON default;
EXPLAIN SELECT * FROM default WHERE TRUE AND type = "xyz" LIMIT 2;
Above query uses primary index instead of ix1 also pushes limit to indexer without
pushing spans.
https://github.com/couchbase/query/blob/master/planner/build_scan.go#L84
This condition is true. It should have been false for AND clause.
Attachments
Issue Links
- links to
For Gerrit Dashboard: MB-31615 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
100492,2 | MB-31615 TRUE predicate not properly handled in where clause | master | query | Status: MERGED | +2 | +1 |
100523,2 | MB-31615 TRUE predicate not properly handled in where clause | alice | query | Status: MERGED | +2 | +1 |
100524,2 | MB-31615 TRUE predicate not properly handled in where clause | vulcan | query | Status: MERGED | +2 | +1 |