[
https://issues.apache.org/jira/browse/ARROW-11973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17302499#comment-17302499
]
Andrew Lamb commented on ARROW-11973:
-------------------------------------
[~jhorstmann] I prefer to follow SQL whenever possible. The other thing we
should review is consistency with the Arrow C++ kernels. I am supportive of
making the Rust implementation more consistent with one / both of them
> [Rust] Boolean AND/OR kernels should follow sql behaviour regarding null
> values
> -------------------------------------------------------------------------------
>
> Key: ARROW-11973
> URL: https://issues.apache.org/jira/browse/ARROW-11973
> Project: Apache Arrow
> Issue Type: New Feature
> Components: Rust, Rust - DataFusion
> Affects Versions: 3.0.0
> Reporter: Jörn Horstmann
> Priority: Major
>
> The AND/OR boolean kernels currently have the same null handling as other
> binary expressions, if either the left or right input is NULL then the result
> will be NULL. The standard sql behaviour is different:
> OR: If one input is TRUE then the result will be TRUE even if the other input
> is NULL
> AND: If one input is FALSE then the result will be FALSE regardless of the
> other input
> This behaviour makes sense if you think of NULL as meaning UNKNOWN.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
