Petar Vasiljevic created SPARK-49164:
----------------------------------------

             Summary: Fix not NullSafeEqual in predicate of SQL query in JDBC 
Relation
                 Key: SPARK-49164
                 URL: https://issues.apache.org/jira/browse/SPARK-49164
             Project: Spark
          Issue Type: Bug
          Components: Spark Core
    Affects Versions: 4.0.0
            Reporter: Petar Vasiljevic


There is a bug in the evaluation of <=> (NullEqualSafe) in 
V2ExpressionSQLBuilder.scala. If there was a predicate like
where not str <=> 'abc' and if there are null values in the table, null tables 
are not returned even though they should. The issue is in how <=> is translated 
to SQL string therefore producing wrong results.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to