Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27572

IN predicate should be nullable

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • SQL
    • None

    Description

      Currently, we are not dealing with the nullability of IN predicate correctly.

      1. IN(In, InSet, InSubquery) with nulls in the left values should return FALSE if the right side is an empty set. Example: `null in (select a from t where false)` should return false.

      2. InSubquery is nullable according to the SQL standard. But we are using a non-nullable ExistenceJoin for the expression `(a in (select b from t)) is null`.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Francis47 Mingcong Han
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated: