[SPARK-40183] Use error class NUMERIC_VALUE_OUT_OF_RANGE for overflow in decimal conversion

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 23/Aug/22 01:20
• Updated: 23/Aug/22 17:01
• Resolved: 23/Aug/22 17:01

Description

Use error class NUMERIC_VALUE_OUT_OF_RANGE for overflow in decimal conversion, instead of the confusing error class `CANNOT_CHANGE_DECIMAL_PRECISION`.

Also, use `decimal.toPlainString` instead of `decimal.toDebugString` in the error message.

Issue Links

• links to: [Github] Pull Request #37620 (gengliangwang)