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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
