[SPARK-40182] Improve ANSI runtime error messages

• Type: Umbrella
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.4.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Gengliang Wang
• Created: 23/Aug/22 01:14
• Updated: 23/Aug/22 01:14

Description

Improve the runtime error messages related to the ANSI SQL mode.

Sub-Tasks

• Use different error classes for numeric/interval divided by 0: Resolved
• Show proper error messages on the overflow errors of table insert: Resolved
• Use different error classes for numeric/interval arithmetic overflow: Resolved
• Use error class NUMERIC_VALUE_OUT_OF_RANGE for overflow in decimal conversion: Resolved