datafusion
datafusion copied to clipboard
ArrayHas does not handle nulls in the haystack correctly.
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