Robert Zeigler updated CAY-1095:
--------------------------------
Attachment: cay-1095.patch
Patch includes fix for the issue + unit test to verify the fix.
Unit test also includes a test to ensure that hsqldb table creation inserts the "CACHED" keyword, since I didn't see anywhere where that was being explicitly guaranteed.
> Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception.
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: CAY-1095
> URL: https://issues.apache.org/cayenne/browse/CAY-1095
> Project: Cayenne
> Issue Type: Bug
> Components: Cayenne Core Library
> Affects Versions: 3.0
> Environment: os x, hsqldb 1.8.0.10, java 1.5
> Reporter: Robert Zeigler
> Assignee: Andrus Adamchik
> Priority: Minor
> Attachments: cay-1095.patch
>
>
> 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);
-- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
This archive was generated by hypermail 2.0.0 : Tue Aug 12 2008 - 23:41:03 EDT