You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Jörn Horstmann (Jira)" <ji...@apache.org> on 2021/03/17 18:56:00 UTC

[jira] [Assigned] (ARROW-11973) [Rust] Boolean AND/OR kernels should follow sql behaviour regarding null values

     [ https://issues.apache.org/jira/browse/ARROW-11973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jörn Horstmann reassigned ARROW-11973:
--------------------------------------

    Assignee: Jörn Horstmann

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