Loading...

XML

Word

Printable

CREATE INDEX ix20 ON default (DISTINCT ARRAY FLATTEN_KEYS(v) FOR v IN a1 END);

UPSERT INTO default VALUES("k01", {"c1":10, "a1": [1,2,3]});

SELECT META(d).id

FROM default d

WHERE ANY v IN a1 SATISFIES abs(v) = 3 END;

Due to false positives and Distinct scan rows eliminated

We should apply filter on indexScan or disable covering

Issue	Resolution
Covering FLATTEN_KEYS() on an array index generated incorrect results. This was because a modified version of the ANY clause was applied after the index which meant false positives were retained and Distinct scan rows were eliminated.	The ANY filter is now applied on an index scan itself when covering an index scan with flatten keys.

No reviews matched the request. Check your Options in the drop-down menu of this sections header.

There are no open Gerrit changes

Hide There are 3 closed Gerrit changes

MB-56579 Apply ANY filter on index scan for covering index scan with flatten keys: Gerrit Review:

MB-56579 Apply ANY filter on index scan for covering index scan with flatten keys: Gerrit Review:

[BP to 7.1.5/7.2.1 MB-56562] - Covering FLATTEN_KEYS() may generate wrong results