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
Our expressions for or + and yield null when either side is null, but when the statement is always true or false regardless of the null-side value, we should yield that instead of propagating nulls.
Describe the bug
Our expressions for or + and yield null when either side is null, but when the statement is always true or false regardless of the null-side value, we should yield that instead of propagating nulls.
To Reproduce
Consider this dataframe:
df.select(df["a"] | df["b"])
anddf.select(df["a"] & df["b"])
both yield a column with two null rows.Same behavior exists in SQL
Expected behavior
df.select(df["a"] | df["b"])
should yield [True, null] since the first row is always true.df.select(df["a"] & df["b"])
should yield [null, False] since the first row is always false.Component(s)
SQL, Other
Additional context
No response
The text was updated successfully, but these errors were encountered: