datafusion icon indicating copy to clipboard operation
datafusion copied to clipboard

ArrayHas does not handle nulls in the haystack correctly.

Open EmilyMatt opened this issue 4 weeks ago • 0 comments

Describe the bug

For Array(0, null, 3) checking for needle 2 The eq array will be (false, null, false) Currently that means we return FALSE

But the result priority should be: Has true -> true Has null -> null Neither -> false

This is relevant for both the scalar and array cases

To Reproduce

As provided above

Expected behavior

No response

Additional context

No response

EmilyMatt avatar Dec 11 '25 16:12 EmilyMatt