Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Workaround
-
2.4.1
-
None
-
None
Description
Currently, Java type double is mapped to NUMERIC for HSQLDB:
HSQLDictionary.java, line 82
doubleTypeName = "NUMERIC";
This seems wrong to me, as HSQLDB's NUMERIC is not a binary floating point type, but represents exact decimal numbers and maps to Java type BigDecimal (see HSQL documentation: http://hsqldb.org/doc/2.0/guide/sqlgeneral-chapt.html#sgc_numeric_types). The corresponding HSQL type for double is, according to this manual, REAL, FLOAT or DOUBLE (all being equivalent).