[jira] [Created] (SPARK-25039) Binary comparison behavior should refer to Teradata

["Yuming Wang (JIRA)" <ji...@apache.org>]

Yuming Wang created SPARK-25039:
-----------------------------------

             Summary: Binary comparison behavior should refer to Teradata
                 Key: SPARK-25039
                 URL: https://issues.apache.org/jira/browse/SPARK-25039
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 2.4.0
            Reporter: Yuming Wang


The main difference is:

# When comparing a {{StringType}} value with a {{NumericType}} value, Spark converts the {{StringType}} data to a {{NumericType}} value. But Teradata converts the {{StringType}} data to a {{DoubleType}} value.
# When comparing a {{StringType}} value with a {{DateType}} value, Spark converts the {{DateType}} data to a {{StringType}} value. But Teradata converts the {{StringType}} data to a {{DateType}} value.
 

More details:
https://github.com/apache/spark/blob/65a4bc143ab5dc2ced589dc107bbafa8a7290931/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/TypeCoercion.scala#L120-L149
https://www.info.teradata.com/HTMLPubs/DB_TTU_16_00/index.html#page/SQL_Reference/B035-1145-160K/lrn1472241011038.html




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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