Repository navigation
array_append mishandles NULL values with non-empty offset ranges #25222
Description
Describe the bug
The result is computed from the input's offset ranges without considering the validity buffer; it is possible for the validity buffer to indicate that a value is NULL, in which case non-empty offsets are allowed but should be ignored.
To Reproduce
CREATE TABLE t AS VALUES ([1,2,3], [1,2,3], 1), ([4,5,6], [7], 2);
CREATE VIEW v AS SELECT column3 AS id, column1 AS l, NULLIF(column1, column2) AS nl FROM t;
SELECT id, nl, array_append(nl, 9), array_prepend(9, nl) FROM v ORDER BY id;
-- row 1: nl = NULL → [1, 2, 3, 9] and [9, 1, 2, 3]
-- expected (matches a true NULL input): [9] and [9]Expected behavior
No response
Additional context
No response
Activity
fix: Ensure `array_append`, `array_prepend` handle NULLs correctly (a…
fix: Ensure `array_append`, `array_prepend` handle NULLs correctly (a…