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

Date functions CURRENT_* have type different from documentation

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 1.26.0
    • None
    • None
    • None

    Description

      The return types of the CURRENT_TIME, CURRENT_DATE and CURRENT_TIMESTAMP operations set in the SqlStdOperatorTable.java (e.g. here) is different from the documentation: they are missing the _WITH_LOCAL_TIMEZONE.
      I am not an expert, but I think changing them to TIME_WITH_LOCAL_TIME_ZONE will already do the trick. I am happy to do a PR, if this is really the only thing to do.

      Attachments

        Issue Links

          relates to

          Sub-task - The sub-task of the issue CALCITE-3612 Add TIME/TIMESTAMP WITH TIME ZONE in calcite

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              nbraun Nils Braun
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: