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

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 4.0.0
• Component/s: Rust, Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/27805
• Assignee: Christoph Schulze
• Reporter: Jörn Horstmann
• Created: 16/Mar/21 08:21
• Updated: 11/Jan/23 08:23
• Resolved: 30/Mar/21 12:25

Description

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.

Issue Links

• links to: GitHub Pull Request #9772