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.
Attachments
For Gerrit Dashboard: MB-49110 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
164177,3 | MB-49110. Disable covering/pushdowns when sargable array index key produces Unkowns | master | query | Status: MERGED | +2 | +1 |
172129,2 | MB-49110. Revise earlier fix regression | master | query | Status: MERGED | +2 | +1 |
172208,3 | new test cases for MB-49110. | master | testrunner | Status: MERGED | +2 | +1 |