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

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

    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
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: