[SPARK-29342] Make casting strings to intervals case insensitive

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 03/Oct/19 08:00
• Updated: 07/Oct/19 16:33
• Resolved: 07/Oct/19 16:33

Description

PostgreSQL is not sensitive to case of interval string values:

maxim=# select cast('10 Days' as INTERVAL);
 interval 
----------
 10 days
(1 row)

but Spark is not tolerant to case:

spark-sql> select cast('INTERVAL 10 DAYS' as INTERVAL);
NULL
spark-sql> select cast('interval 10 days' as INTERVAL);
interval 1 weeks 3 days

 

Issue Links

• links to: GitHub Pull Request #26010