[SPARK-28503] Return null result on cast an out-of-range value to a integral type

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Gengliang Wang
• Created: 24/Jul/19 16:31
• Updated: 22/Aug/19 12:42
• Resolved: 22/Aug/19 12:42

Description

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.

Issue Links

• links to: GitHub Pull Request #25300