Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.5, 7.0.0, 7.1.0
-
Untriaged
-
1
-
Unknown
Description
Repro:
UPSERT INTO default VALUES("k001", {"a":1}); |
UPSERT INTO default VALUES("k002", {"a":1, "reviews":1}); |
SELECT META().id FROM default d USE INDEX (ix1) WHERE d.a = 1 AND ANY v IN d.reviews SATISFIES v.x IS NULL END; -- returns k002 |
|
SELECT META().id FROM default d USE INDEX (ix1) WHERE d.a = 1 AND ANY v IN d.reviews SATISFIES v.x IS MISSING END; -- returns k001 |
Try with primary index gives none
array index key doesn't know if reviews is null or v.x is null false positives. We can't rely on the index key value.