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

JDBC adapter should transform timestamp arithmetic for target database

    XMLWordPrintableJSON

    Details

      Description

      JDBC adapter should transform timestamp arithmetic for target database.

      There are two ways in Calcite to add intervals to timestamps: the TIMESTAMP_ADD function and the "<timestamp> + <interval>" operator.

      The attached document (authored by James Doung) describes their pros and cons.

        Attachments

        1. Datetime Addition - Calcite.pdf
          104 kB
          Julian Hyde

          Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2836 Remove maven-compiler-plugin from calcite-plus module pom.xml

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

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2359 Inconsistent behavior when casting interval literals to integer

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Task - A task that needs to be done. CALCITE-2337 Release Calcite 1.17.0

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #721

          Web Link GitHub Pull Request #2466

          Web Link GitHub Pull Request #2467

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 40m
                  40m