[SPARK-40209] Incorrect value in the error message of NUMERIC_VALUE_OUT_OF_RANGE

• 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: Max Gekk
• Reporter: Max Gekk
• Created: 24/Aug/22 19:36
• Updated: 25/Aug/22 07:11
• Resolved: 25/Aug/22 07:11

Description

The example below demonstrates the issue:

spark-sql> select cast(interval '10.123' second as decimal(1, 0));
[NUMERIC_VALUE_OUT_OF_RANGE] 0.000010 cannot be represented as Decimal(1, 0). If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.

The value 0.000010 is not related to 10.123.

Issue Links

• links to: [Github] Pull Request #37649 (MaxGekk)