[CALCITE-5217] Implement unparseSqlIntervalLiteral in the Firebolt dialect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.31.0
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Aymeric Dispa
• Reporter: Aymeric Dispa
• Created: 23/Jul/22 08:30
• Updated: 07/Feb/23 22:33
• Resolved: 29/Nov/22 15:27

Description

The syntax used by Firebolt for the operator INTERVAL does not match with the query generated. To fix it, the method unparseSqlIntervalLiteral must be implemented in the dialect.

What we get with the current dialect:

<date_column> + INTERVAL '1' DAY 

 

Format supported by Firebolt

<date_column> + INTERVAL '1 DAY'  

Issue Links

• links to: Github Pull request 2860
• links to: GitHub Pull Request #2860