Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-19162

Sql. Trim all less than millisecond information from timestamp.

    XMLWordPrintableJSON

Details

    Description

      Trim useful timestamp part:

      CREATE TABLE timestamps(id INTEGER PRIMARY KEY, i TIMESTAMP(9));
INSERT INTO timestamps VALUES (101, TIMESTAMP '2023-03-29 08:22:33.005007');
SELECT i from timestamps; <--- expect inserted, obtain trimmed : 2023-03-29 08:22:33.005

      The root cause :
      RelJson#toJson() -> getValue3 -> getValue2 ->
      RexLiteral#getValueAs ->
      case TIMESTAMP:
      if (clazz == Long.class)

      { return clazz.cast(((TimestampString) value).getMillisSinceEpoch()); <-- here info is loosed. }

      Also CURRENT_TIMESTAMP return only 3 digits after last dot, don`t take into account TIMESTAMP(precision)

      The same for default value :
      testInsertDefaultValue ->
      DdlSqlToCommandConverter#fromLiteral
      case TIMESTAMP:

      Attachments

        Issue Links

          Blocked

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5266 Increase precision of TIMESTAMP, INTERVAL types to microseconds, nanoseconds

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5308 Add support to Avatica for microsecond-precision timestamps

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

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-19000 testCurrentDateTimeTimeStamp fails on Windows

          • Major - Major loss of function.
          • Open
          incorporates

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-15418 Calcite engine. TIMESTAMPDIFF function returns INTEGER type for MICROSECOND time unit

          • Major - Major loss of function.
          • Open
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-15622 Calcite. TIME and TIMESTAMP types are trim milliseconds.

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

          Web Link GitHub Pull Request #3916

          Activity

            People

              mzhuravkov Maksim Zhuravkov
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

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