[ 
https://issues.apache.org/jira/browse/ARROW-11973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17302318#comment-17302318
 ] 

Jörn Horstmann commented on ARROW-11973:
----------------------------------------

[~alamb] [~andygrove] FYI and do you think anyone relies on the current 
behaviour?

> [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)

Reply via email to