[
https://issues.apache.org/jira/browse/CALCITE-2406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16672679#comment-16672679
]
Enrico Olivelli commented on CALCITE-2406:
------------------------------------------
[~julianhyde] I have updated the title and description, thanks.
When I will have cycles I can work on this
> SqlValidator: allow to use raw string literals for timestamps as in MySQL
> -------------------------------------------------------------------------
>
> Key: CALCITE-2406
> URL: https://issues.apache.org/jira/browse/CALCITE-2406
> Project: Calcite
> Issue Type: New Feature
> Components: babel
> Affects Versions: 1.17.0
> Reporter: Enrico Olivelli
> Assignee: Julian Hyde
> Priority: Major
>
> 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
>
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
