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
For Gerrit Dashboard: MB-30946 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
98393,3 | MB-30946 Empty array from index scan not working properly when backfill is used | master | query | Status: MERGED | +2 | +1 |
98394,2 | MB-30946 Empty array from index scan not working properly when backfill is used | alice | query | Status: MERGED | +2 | +1 |
98400,2 | MB-30946 Empty array from index scan not working properly when backfill is used | vulcan | query | Status: MERGED | +2 | +1 |
98402,2 | MB-30946 Empty array from index scan not working properly when backfill is used | spock | query | Status: MERGED | +2 | +1 |
98791,4 | automation for MB-28636 and MB-30946 | spock | testrunner | Status: MERGED | +2 | +1 |