`array_has_any/array_has_all` results depend on other rows when needles are NULL

[yashrb24]

Describe the bug

array_has_any and array_has_all return different results for the same row
depending on whether another row has a non-empty needle.

To Reproduce

WITH t(id, haystack, needle) AS (
  VALUES
    (1, [1, 2], arrow_cast(NULL, 'List(Int64)')),
    (2, [3, 4], arrow_cast(NULL, 'List(Int64)'))
)
SELECT array_has_any(haystack, needle),
       array_has_all(haystack, needle)
FROM t
ORDER BY id;

This is returning

false true
false true

If the second needle is changed from NULL to something non-null like [9], the first row returns

NULL NULL

Expected behavior

The result should be all nulls

Additional context

No response

[yashrb24]

take