[CALCITE-5244] Postgres dialect should support traditional postgres interval format

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: babel
• Assignee: Unassigned
• Reporter: Dmitry Sysolyatin
• Created: 25/Aug/22 12:39
• Updated: 02/Sep/22 23:09

Description

Postgres dialect should support "Traditional Postgres format" for interval. https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-INPUT

Query

select interval '1 year 3 hours 20 minutes 10 seconds 5 milliseconds'

throws exception:

Caused by: java.lang.RuntimeException: org.apache.calcite.sql.parser.SqlParseException: Encountered "\'1 year 3 hours 20 minutes 10 seconds 5 milliseconds\' <EOF>" at line 1, column 17.