Gengliang Wang created SPARK-28503:
--------------------------------------
Summary: Return null result on cast an out-of-range value to a
numeric type
Key: SPARK-28503
URL: https://issues.apache.org/jira/browse/SPARK-28503
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.0.0
Reporter: Gengliang Wang
Currently, when we convert an out-of-range value to a numeric type, the value
is unexpected
scala> spark.sql("select cast(327689 as short)").show()
+------------------------+
|CAST(327689 AS SMALLINT)|
+------------------------+
| 9|
+------------------------+
The result is actually 327689.toShort (327689 & 0xffff).
For such cases, I think we should return null.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
