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

Implement EXTRACT for time unit DOW, DOY; and fix CENTURY

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.13.0
    • Component/s: None
    • Labels:
      None

      Description

      Implement EXTRACT for time units DOW, DOY and others introduced in CALCITE-1606.

      Fix EXTRACT(CENTURY FROM ...), which previously just divided the year by 100, and a similar bug in MILLENNIUM.

      Requires CALCITE-1609 and therefore has to wait for an Avatica release.

        Issue Links

          Activity

          Hide
          julianhyde Julian Hyde added a comment -

          Also update the test case for CALCITE-1664, which should be fixed by upgrading to avatica-1.10.

          Show
          julianhyde Julian Hyde added a comment - Also update the test case for CALCITE-1664 , which should be fixed by upgrading to avatica-1.10.
          Hide
          julianhyde Julian Hyde added a comment -

          Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/6cb4d45b.

          However, we didn't remove addMonths and related methods yet; CALCITE-1639 had made some improvements in Calcite which are not in Avatica as of avatica-1.10.

          Show
          julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/6cb4d45b . However, we didn't remove addMonths and related methods yet; CALCITE-1639 had made some improvements in Calcite which are not in Avatica as of avatica-1.10.
          Hide
          jcamachorodriguez Jesus Camacho Rodriguez added a comment -

          Resolved in release 1.13.0 (2017-06-26).

          Show
          jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.13.0 (2017-06-26).

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              julianhyde Julian Hyde
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development