Uploaded image for project: 'Apache Arrow'
  1. Apache Arrow
  2. ARROW-11973

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

    XMLWordPrintableJSON

Details

    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.

      Attachments

        Issue Links

          Activity

            People

              ch-sc Christoph Schulze
              jhorstmann Jörn Horstmann
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 10m
                  2h 10m