Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-2141

Fix invalid null handling with NOT IN clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.11.0, 0.11.1, 0.11.2, 0.11.3
    • 0.13.0
    • Physical Operator, QueryMaster
    • None

    Description

      If the subquery of a NOT IN clause returns at least one null value, then the NOT IN predicate should evaluate to false. See http://www.dbspecialists.com/files/presentations/semijoins.html.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. TAJO-2135 Invalid join result when join key columns contain nulls

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Activity

            People

              jihoonson Jihoon Son
              jihoonson Jihoon Son
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: