You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
array_has has inconsistent null handling for scalars and arrays #13682
array_has handles nulls differently for scalars and arrays. Scalars return null if all the left hand side values are null, while arrays don't care what values in the left hand side are null. Additionally, other systems like Spark and Postgres have different null behavior, such that if at least one element of the left hand side is null, return null instead of false. I can't find any definitive SQL standard for this, but it might be good to behave consistent with those other systems.
Activity