Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2602

TIMESTAMP value is truncated when return to client

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.3.1.4
    • 10.6.1.0
    • Network Client
    • None
    • Normal
    • Repro attached
    • Deviation from standard, Embedded/Client difference, Wrong query result

    Description

      In ParameterMappingTest I see the following differences between embedded and client. Client is truncating the TIMESTAMP value. Look for this bug number in the test for reproduction.

      case java.sql.Types.TIMESTAMP:
      if (param == 2)
      if (usingEmbedded())
      assertEquals("2004-03-12 21:14:24.938222433", val.toString());
      else
      assertEquals("2004-03-12 21:14:24.938222", val.toString());
      else if (param == 3)
      if (usingEmbedded())
      assertEquals("2004-04-12 04:25:26.462983731", val.toString());
      else
      assertEquals("2004-04-12 04:25:26.462983", val.toString());
      break;

      Attachments

        1. d2602.java
          2 kB
          Katherine Marsden
        2. ASF.LICENSE.NOT.GRANTED--derby-2602-01-af-dontTruncate.diff
          33 kB
          Richard N. Hillegas
        3. ASF.LICENSE.NOT.GRANTED--derby-2602-01-ae-dontTruncate.diff
          31 kB
          Richard N. Hillegas
        4. ASF.LICENSE.NOT.GRANTED--derby-2602-01-ad-dontTruncate.diff
          32 kB
          Richard N. Hillegas

        Issue Links

          Activity

            People

              rhillegas Richard N. Hillegas
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: