Derby
  1. Derby
  2. DERBY-4626

Timestamp truncated when converted to string with explicit calendar

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: 10.5.3.2, 10.6.2.4, 10.7.1.1
    • Component/s: SQL
    • Labels:
      None
    • Bug behavior facts:
      Wrong query result

      Description

      When setting the value of a VARCHAR parameter with setTimestamp() the timestamp is truncated to microsecond resolution if a calendar is specified. Nanosecond resolution is preserved when a calendar is not specified. These two methods should behave the same way. Since Derby supports nanosecond resolution, the timestamps should not be truncated.

      1. test.diff
        2 kB
        Knut Anders Hatlen
      2. TimestampToVarchar.java
        1 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12508974 ] Default workflow, editable Closed status [ 12801141 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Mike Matrigali made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Assignee Mike Matrigali [ mikem ] C.S. Nirmal J. Fernando [ nirmal ]
          Fix Version/s 10.5.3.2 [ 12315436 ]
          Fix Version/s 10.6.2.3 [ 12315434 ]
          Resolution Fixed [ 1 ]
          Mike Matrigali made changes -
          Assignee C.S. Nirmal J. Fernando [ nirmal ] Mike Matrigali [ mikem ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-4994 [ DERBY-4994 ]
          Nirmal Fernando made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Issue & fix info [Repro attached]
          Resolution Fixed [ 1 ]
          Nirmal Fernando made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Attachment test.diff [ 12455155 ]
          Nirmal Fernando made changes -
          Assignee C.S. Nirmal J. Fernando [ nirmal ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-2602 [ DERBY-2602 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-4614 [ DERBY-4614 ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Repro attached]
          Knut Anders Hatlen made changes -
          Attachment TimestampToVarchar.java [ 12442417 ]
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4625 [ DERBY-4625 ]
          Knut Anders Hatlen created issue -

            People

            • Assignee:
              Nirmal Fernando
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development