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

JDBC metadata gives incorrect lengths for timestamps

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment