[SPARK-47072] Wrong error message for incorrect ANSI intervals

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.4.2, 3.5.0, 4.0.0
• Fix Version/s: 4.0.0, 3.5.2, 3.4.3
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 16/Feb/24 07:54
• Updated: 19/Feb/24 07:32
• Resolved: 16/Feb/24 11:20

Description

When Spark SQL cannot recognise ANSI interval, it outputs wrong pattern for particular ANSI interval. For example, it cannot recognise year-month interval, but says about day-time interval:

spark-sql (default)> select interval '-\t2-2\t' year to month;

Interval string does not match year-month format of `[+|-]d h`, `INTERVAL [+|-]'[+|-]d h' DAY TO HOUR` when cast to interval year to month: -	2-2	. (line 1, pos 16)

== SQL ==
select interval '-\t2-2\t' year to month
----------------^^^

Issue Links

• links to: GitHub Pull Request #45127
• links to: GitHub Pull Request #45139
• links to: GitHub Pull Request #45140