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
This condition is true. It should have been false for AND clause.
- links to