[jira] [Created] (SPARK-35187) Failure on minimal interval literal

["Max Gekk (Jira)" <ji...@apache.org>]

Max Gekk created SPARK-35187:
--------------------------------

             Summary: Failure on minimal interval literal
                 Key: SPARK-35187
                 URL: https://issues.apache.org/jira/browse/SPARK-35187
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.2.0
            Reporter: Max Gekk


If the sign '-' inside of interval string, everything is fine after https://github.com/apache/spark/commit/bb5459fb26b9d0d57eadee8b10b7488607eeaeb2:

{code:sql}
spark-sql> SELECT INTERVAL '-178956970-8' YEAR TO MONTH;
-178956970-8
{code}
but the sign outside of interval string is not handled properly:
{code:sql}
spark-sql> SELECT INTERVAL -'178956970-8' YEAR TO MONTH;
Error in query:
Error parsing interval year-month string: integer overflow(line 1, pos 16)

== SQL ==
SELECT INTERVAL -'178956970-8' YEAR TO MONTH
----------------^^^
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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