[CALCITE-2406] SqlValidator: allow to use raw string literals for timestamps as in MySQL

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.17.0
• Component/s: babel
• Assignee: Unassigned
• Reporter: Enrico Olivelli
• Created: 09/Jul/18 10:32
• Updated: 22/Feb/19 01:21

Description

I have some case of incompatibility between MySQL (actually on HerdDB which is a replacement for MySQL) and Calcite around timestamp syntax.

In MySQL it is legal to write timestamp literals in this form:

INSERT INTO table(tscolum) values('2018-12-22 22:33:00.333')

This is currently not possible for standard Calcite SQL Parser/Validator.

 

It is not a requirement that the Validator converts the literal directly, a string will be fine, so that downstream the string will be parsed according to the Database/User/Session settings

 

 

 

Issue Links

• is a clone of: CALCITE-2405 In Babel parser: allow to use some reserved keyword as identifier