[CAY-1095] Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0M5
• Component/s: Core Library
• Environment: os x, hsqldb 1.8.0.10, java 1.5
• Assignee: Kevin Menard
• Reporter: Robert Zeigler
• Created: 13/Aug/08 03:10
• Updated: 08/Nov/08 22:31
• Resolved: 23/Aug/08 15:56

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);