[jira] [Created] (SPARK-39917) Use different error classes for numeric/interval arithmetic overflow

["Gengliang Wang (Jira)" <ji...@apache.org>]

Gengliang Wang created SPARK-39917:
--------------------------------------

             Summary: Use different error classes for numeric/interval arithmetic overflow
                 Key: SPARK-39917
                 URL: https://issues.apache.org/jira/browse/SPARK-39917
             Project: Spark
          Issue Type: Task
          Components: SQL
    Affects Versions: 3.4.0
            Reporter: Gengliang Wang
            Assignee: Gengliang Wang


Currently, when  arithmetic overflow errors happen under ANSI mode, the error messages are like
[ARITHMETIC_OVERFLOW] long overflow. Use 'try_multiply' to tolerate overflow and return NULL instead. If necessary set spark.sql.ansi.enabled to "false" 

 

The "(except for ANSI interval type)" part is confusing. We should remove it for the numeric arithmetic operations and have a new error class for the interval division error: INTERVAL_ARITHMETIC_OVERFLOW



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org