[SPARK-34744] Improve error message for casting cause overflow error

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: angerszhu
• Reporter: Yuming Wang
• Created: 15/Mar/21 14:50
• Updated: 27/Mar/21 03:19
• Resolved: 27/Mar/21 03:17

Description

For example:

set spark.sql.ansi.enabled=true;
select tinyint(128) * tinyint(2);

Error message:

Casting 128 to scala.Byte$ causes overflow

Expected:

Casting 128 to tinyint causes overflow

We should use DataType's catalogString.

Issue Links

• links to: [Github] Pull Request #31971 (AngersZhuuuu)
• links to: [Github] Pull Request #31971 (AngersZhuuuu)