[
https://issues.apache.org/cayenne/browse/CAY-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
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.
