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

            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