[ https://issues.apache.org/jira/browse/ARROW-11973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17302542#comment-17302542 ]
Joris Van den Bossche commented on ARROW-11973: ----------------------------------------------- bq. The other thing we should review is consistency with the Arrow C++ kernels. In C++, both options are available as different kernels: "or" and "or_kleene", etc > [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)