Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
3.0
-
None
-
os x, hsqldb 1.8.0.10, java 1.5
Description
According to the documentation on hsql's website, hsqldb should support precision on DOUBLE types, so the following:
create table foo(bar DOUBLE(22));
should be valid. However, the docs are apparently out of sync with reality, as the above produces the following feedback:
java.sql.SQLException: Unexpected token in statement [CREATE CACHED TABLE foo (bar DOUBLE(22]
This is now documented in the following bug report:
http://sourceforge.net/tracker/index.php?func=detail&aid=2048932&group_id=23316&atid=378131
Cayenne's hsqldb adapter should work around this hsqldb problem by dropping the precision statement for DOUBLE, resulting in sql like:
create table foo(bar DOUBLE);