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

            depends upon

            Bug - A problem which impairs or prevents the functions of the product. CALCITE-1608 Move addMonths and subtractMonths from Calcite to Avatica

            • Major - Major loss of function.
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CALCITE-1612 Release Avatica 1.10

            • Major - Major loss of function.
            • Closed

            Improvement - An improvement or enhancement to an existing feature or task. CALCITE-1606 Add missing support for datetime JDBC functions

            • Minor - Minor loss of function, or other problem where easy workaround is present.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              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
              Permalink
              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
              Permalink
              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