Derby
  1. Derby
  2. DERBY-74

SQLDecimal.getWholeDigits returns invalid result on JDK1.5.0

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.1.1.0
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      JDK1.5.0

      Description

      With JDK1.5.0 the behaviour of BigDecimal.toString() has changed (thanks Sun) and for numbers < 1e-6 it now returns a String in exponential syntax. This causes the number of digits to be calculated incorrectly.

      As a result, the ejbql test fails as the following snippet fails:
      create table myDecimal (b DECIMAL(31,31))
      insert into myDecimal VALUES(1e-30)

        Activity

        Jeremy Boynes created issue -
        Jeremy Boynes made changes -
        Field Original Value New Value
        Attachment derby_getWholeDigits_jdk15.patch [ 18199 ]
        Daniel John Debrunner made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Kathey Marsden made changes -
        Affects Version/s 10.1.1.0 [ 10993 ]
        Fix Version/s 10.1.1.0 [ 10993 ]
        Andrew McIntyre made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 38515 ] Default workflow, editable Closed status [ 12800324 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Jeremy Boynes
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development