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

Return type of "datetime + interval" expression

        Details

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

          Description

          Per the SQL standard, the return type of "datetime + interval" is the same as the type of "datetime". (Postgres, for instance, always widens the result to TIMESTAMP; this is wrong.)

          Also, when adding or subtracting to a TIME value, make sure the result stays within the range 00:00:00..23:59:59.

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            julianhyde Julian Hyde added a comment -

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

            Show
            julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d8c4d73f .
            Hide
            Permalink
            julianhyde Julian Hyde added a comment -

            Resolved in release 1.12.0 (2017-03-24).

            Show
            julianhyde Julian Hyde added a comment - Resolved in release 1.12.0 (2017-03-24).

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Development