Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2406

SqlValidator: allow to use raw string literals for timestamps as in MySQL

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: babel
    • Labels:
      None

      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

       

       

       

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              eolivelli Enrico Olivelli

              Dates

              • Created:
                Updated:

                Issue deployment