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

JDBC metadata gives incorrect lengths for timestamps

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.7.1.1
    • 10.7.1.4, 10.8.1.2
    • SQL
    • None
    • Newcomer
    • Deviation from standard, Wrong query result

    Description

      While looking into DERBY-2602, I noticed that Derby gives the wrong lengths for various fields in the JDBC metadata for timestamps. I will attach a spec describing what I think should be done to correct this.

      Attachments

        1. ASF.LICENSE.NOT.GRANTED--derby-4614-fs.html
          9 kB
          Richard N. Hillegas
        2. d4614_hang.java
          0.5 kB
          Knut Anders Hatlen
        3. derby_4614-2.diff
          84 kB
          Nirmal Fernando
        4. derby-4614-01-aa-warmedUp.diff
          110 kB
          Richard N. Hillegas
        5. derby-4614-01-ab-warmedUp.diff
          110 kB
          Richard N. Hillegas
        6. derby-4614-01-ac-warmedUp.diff
          120 kB
          Richard N. Hillegas
        7. derby-4614-01-ad-warmedUp.diff
          120 kB
          Richard N. Hillegas
        8. derby-4614-01-ae-warmedUp.diff
          120 kB
          Richard N. Hillegas
        9. derby-4614-02-ab-compatProblem.diff
          2 kB
          Richard N. Hillegas
        10. derby-4614-1.diff
          87 kB
          Nirmal Fernando
        11. releaseNote.html
          5 kB
          Richard N. Hillegas
        12. releaseNote.html
          5 kB
          Richard N. Hillegas

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4626 Timestamp truncated when converted to string with explicit calendar

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2602 TIMESTAMP value is truncated when return to client

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

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4625 TIMESTAMP function doesn't accept nanoseconds

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

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: