You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Mark Struberg (Jira)" <ji...@apache.org> on 2021/04/04 11:51:00 UTC

[jira] [Created] (OPENJPA-2859) [HSQLDB] HSQLDictionary wrongly maps double to NUMBER without precision

Mark Struberg created OPENJPA-2859:
--------------------------------------

             Summary: [HSQLDB] HSQLDictionary wrongly maps double to NUMBER without precision
                 Key: OPENJPA-2859
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2859
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 3.1.2
            Reporter: Mark Struberg
            Assignee: Mark Struberg
             Fix For: 3.1.3


Right now we create a {{NUMERIC}} field without any precision digits for double fields. This results in zero decimal fractions, which is clearly wrong.

We should rather use DOUBLE SQL type, which is a 64bit 'aprox' type. If someone wants to use a fixed prec+scale then use {{BigDecimal}} which will be mapped as {{DECIMAL(n,m)}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)