Derby
  1. Derby
  2. DERBY-3398

Support min/max values for Java types float/double in real/double columns

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: 10.10.1.1
    • Component/s: SQL
    • Urgency:
      Normal
    • Issue & fix info:
      Release Note Needed

      Description

      Derby doesn't support the entire range of valid (finite) values of the Java primitive types double/float in columns with SQL type DOUBLE or REAL. This appears to be a limitation that was introduced for compatibility with DB2. There have been some requests on derby-user that we lift this restriction.

      The restriction is enforced by the methods normalizeREAL() and normalizeDOUBLE() in org.apache.derby.iapi.types.NumberDataType.

      1. derby-3398.diff
        13 kB
        Dag H. Wanvik
      2. derby-3398.status
        0.7 kB
        Dag H. Wanvik
      3. derby-3398-2.diff
        37 kB
        Dag H. Wanvik
      4. derby-3398-3.diff
        42 kB
        Dag H. Wanvik
      5. derby-3398-3.stat
        0.9 kB
        Dag H. Wanvik
      6. derby-3398-4.diff
        67 kB
        Dag H. Wanvik
      7. derby-3398-5.diff
        47 kB
        Dag H. Wanvik
      8. derby-3398-5.stat
        0.9 kB
        Dag H. Wanvik
      9. derby-3398-7.diff
        415 kB
        Dag H. Wanvik
      10. derby-3398-7.stat
        4 kB
        Dag H. Wanvik
      11. releaseNote.html
        5 kB
        Dag H. Wanvik
      12. releaseNote.html
        5 kB
        Dag H. Wanvik
      13. derby-3398-8.diff
        415 kB
        Dag H. Wanvik
      14. releaseNote.html
        5 kB
        Dag H. Wanvik
      15. releaseNote.html
        5 kB
        Rick Hillegas

        Issue Links

          Activity

          Knut Anders Hatlen created issue -
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-5534 [ DERBY-5534 ]
          Mamta A. Satoor made changes -
          Labels derby_triage10_10
          Urgency Normal [ 10052 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398.diff [ 12568200 ]
          Attachment derby-3398.status [ 12568201 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-3290 [ DERBY-3290 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-2.diff [ 12568391 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-3.diff [ 12568795 ]
          Attachment derby-3398-3.stat [ 12568796 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-4.diff [ 12569153 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-5.diff [ 12569471 ]
          Attachment derby-3398-5.stat [ 12569472 ]
          Dag H. Wanvik made changes -
          Assignee Dag H. Wanvik [ dagw ]
          Dag H. Wanvik made changes -
          Issue & fix info Patch Available,Release Note Needed [ 10102, 10101 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-7.diff [ 12569905 ]
          Attachment derby-3398-7.stat [ 12569906 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-7.diff [ 12569905 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-7.stat [ 12569906 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-7.diff [ 12569909 ]
          Attachment derby-3398-7.stat [ 12569910 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12569912 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12569913 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12569912 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12569914 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12569913 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12570069 ]
          Dag H. Wanvik made changes -
          Attachment derby-3398-8.diff [ 12570077 ]
          Dag H. Wanvik made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info Release Note Needed,Patch Available [ 10101, 10102 ] Release Note Needed [ 10101 ]
          Fix Version/s 10.10.0.0 [ 12321550 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Link This issue is related to DERBY-6083 [ DERBY-6083 ]
          Dag H. Wanvik made changes -
          Attachment releaseNote.html [ 12570438 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12573145 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12423073 ] Default workflow, editable Closed status [ 12802396 ]

            People

            • Assignee:
              Dag H. Wanvik
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development