Details
Description
See CBSE-5629.
Here is a simplified repro:
INSERT INTO default VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}), |
VALUES(UUID(),{"severity":"low","deferred":[]}); |
CREATE INDEX ix1 ON default(severity,deferred); |
SELECT META().id, deferred FROM default WHERE severity = "low"; |
SELECT META().id, deferred FROM default WHERE severity = "low" AND EVERY v IN deferred SATISFIES v != "X" END; |
\set -scan_cap 2; |
SELECT META().id, deferred FROM default WHERE severity = "low"; |
SELECT META().id, deferred FROM default WHERE severity = "low" AND EVERY v IN deferred SATISFIES v != "X" END; |
When scan_cap is set to a small number (2 above) backfill is used and the empty array deferred is showing up as "null" instead of "[]" in the first query, and in the second query when a predicate is used on the array it returns incorrect result.
Attachments
Issue Links
- relates to
-
MB-31017 CLONE - Empty array from index scan not working properly when backfill is used
- Closed