Derby
  1. Derby
  2. DERBY-4614

JDBC metadata gives incorrect lengths for timestamps

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.7.1.1
    • Fix Version/s: 10.7.1.4, 10.8.1.2
    • Component/s: SQL
    • Labels:
      None
    • Issue & fix info:
      Newcomer
    • Bug behavior facts:
      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.

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

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-2602 [ DERBY-2602 ]
          Rick Hillegas made changes -
          Attachment derby-4614-fs.html [ 12441733 ]
          Rick Hillegas made changes -
          Issue & fix info [Newcomer]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-4625 [ DERBY-4625 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-4626 [ DERBY-4626 ]
          Nirmal Fernando made changes -
          Assignee C.S. Nirmal J. Fernando [ nirmal ]
          Nirmal Fernando made changes -
          Attachment derby-4614-1.diff [ 12453614 ]
          Nirmal Fernando made changes -
          Issue & fix info [Newcomer] [Newcomer, Patch Available]
          Nirmal Fernando made changes -
          Attachment derby_4614-2.diff [ 12454843 ]
          Nirmal Fernando made changes -
          Assignee C.S. Nirmal J. Fernando [ nirmal ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Patch Available, Newcomer] [Newcomer]
          Rick Hillegas made changes -
          Attachment derby-4614-01-aa-warmedUp.diff [ 12460198 ]
          Rick Hillegas made changes -
          Attachment derby-4614-01-ab-warmedUp.diff [ 12460276 ]
          Rick Hillegas made changes -
          Attachment derby-4614-01-ac-warmedUp.diff [ 12465246 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12465250 ]
          Rick Hillegas made changes -
          Attachment derby-4614-01-ad-warmedUp.diff [ 12465263 ]
          Rick Hillegas made changes -
          Attachment derby-4614-01-ae-warmedUp.diff [ 12465379 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Affects Version/s 10.7.1.2 [ 12315902 ]
          Affects Version/s 10.8.0.0 [ 12315561 ]
          Affects Version/s 10.6.1.0 [ 12313727 ]
          Knut Anders Hatlen made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Assignee Rick Hillegas [ rhillegas ]
          Knut Anders Hatlen made changes -
          Attachment d4614_hang.java [ 12465893 ]
          Rick Hillegas made changes -
          Attachment derby-4614-02-ab-compatProblem.diff [ 12466167 ]
          Rick Hillegas made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.8.0.0 [ 12315561 ]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.7.1.2 [ 12315902 ]
          Affects Version/s 10.7.1.1 [ 12315564 ]
          Affects Version/s 10.8.0.0 [ 12315561 ]
          Affects Version/s 10.7.1.2 [ 12315902 ]
          Rick Hillegas made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12472335 ]
          Rick Hillegas made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Fix Version/s 10.8.1.0 [ 12315561 ]
          Rick Hillegas made changes -
          Fix Version/s 10.8.1.2 [ 12316362 ]
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12508314 ] Default workflow, editable Closed status [ 12801704 ]

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development