[SPARK-35187] Failure on minimal interval literal

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: angerszhu
• Reporter: Max Gekk
• Created: 22/Apr/21 09:52
• Updated: 22/Apr/21 18:59
• Resolved: 22/Apr/21 18:59

Description

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

spark-sql> SELECT INTERVAL '-178956970-8' YEAR TO MONTH;
-178956970-8

but the sign outside of interval string is not handled properly:

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
----------------^^^

Issue Links

• links to: [Github] Pull Request #32296 (AngersZhuuuu)
• links to: [Github] Pull Request #32296 (AngersZhuuuu)