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

From: Kevin Menard (JIRA) ("Kevin)
Date: Sat Aug 23 2008 - 11:57:11 EDT

  • Next message: Marcin Skladaniec (JIRA): "[jira] Commented: (CAY-795) Horizontal inheritance"

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

    Kevin Menard closed CAY-1095.
    -----------------------------

           Resolution: Fixed
        Fix Version/s: 3.0

    Patch looked good. Applied mostly as is.

    > 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
    > Fix For: 3.0
    >
    > 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 : Sat Aug 23 2008 - 11:57:33 EDT