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

["Kevin Menard (JIRA)" <de...@cayenne.apache.org>]

     [ https://issues.apache.org/cayenne/browse/CAY-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Menard reassigned CAY-1095:
---------------------------------

    Assignee: Kevin Menard  (was: Andrus Adamchik)

> 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: Kevin Menard
>            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.