Description
INSERT INTO default VALUES("k01",{"k0":"XYZ","ka":["abc"]}); |
CREATE INDEX ix11 ON default(k0,k1,DISTINCT ARRAY v FOR v IN ka END); |
SELECT META().id FROM default WHERE k0 = "XYZ" AND ANY v IN ka SATISFIES v LIKE "def%" END; |
Above query covers it shouldn't because Array key is not pushed to indexer due to k1 is missing in predicate. We need ka in the index re-apply predicate. Array index keys can be covered without array in index when all predicates pushed to indexer and no false positives possible. Otherwise we can't use filtercovers for that arraykey