Github user mgaido91 commented on a diff in the pull request:

    https://github.com/apache/spark/pull/21403#discussion_r199086016
  
    --- Diff: 
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/predicates.scala
 ---
    @@ -161,33 +161,38 @@ case class Not(child: Expression)
            true
       """)
     // scalastyle:on line.size.limit
    -case class In(value: Expression, list: Seq[Expression]) extends Predicate {
    +case class In(values: Seq[Expression], list: Seq[Expression]) extends 
Predicate {
    --- End diff --
    
    I am not sure. The behavior when comparing structs in not uniform among 
different DBs. Hive doesn't allow `=` on structs. Postgres and Presto does, but 
their behavior with nulls is not consistent and it is different from ours. In 
particular, comparing a struct containing a `null` returns `null` on Postgres 
and causes an exception in Presto (we return `false` instead). This is causing 
another problem which has been reported in another JIRA for which we can return 
results different from Postgres and Oracle (SPARK-24395).


---

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to