[SPARK-29369] Accept strings without `interval` prefix in casting to intervals

• 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: 07/Oct/19 08:13
• Updated: 14/Oct/19 15:51
• Resolved: 14/Oct/19 15:42

Description

PostgreSQL allows strings without the `interval` prefix while casting a string to an interval:

maxim=# select cast('1 day' as interval);
 interval 
----------
 1 day
(1 row)
maxim=# select interval '1 microsecond';
    interval     
-----------------
 00:00:00.000001
(1 row)

See https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-INPUT

Issue Links

• links to: GitHub Pull Request #26079