Re: hsqldb, doubles, and precision

From: Aristedes Maniatis (ar..sh.com.au)
Date: Tue Aug 12 2008 - 21:36:03 EDT

  • Next message: Robert Zeigler: "Re: hsqldb, doubles, and precision"

    On 13/08/2008, at 11:02 AM, Robert Zeigler wrote:

    > Hi all,
    >
    > While writing some unit tests today, I found that hsqldb was choking
    > on a table creation statement along the lines of:
    >
    > CREATE CACHED TABLE foo (bar DOUBLE(22))
    >
    > A bit of research showed that this is a known issue: hsqldb doesn't
    > support precision on doubles.
    > I found some workarounds suggested here on the list (such as
    > dropping the precision for doubles in the modeler; dropping
    > precision when setting up the test environment, in code, and so
    > forth). But I got to wondering why there wasn't a fix at the adapter
    > level? Shouldn't this be something that the hsqldb adapter takes
    > care of automatically? If so, I'll file a jira, and will likely
    > contribute a patch. This is running 3.0M4, btw.

    If you do write a patch, please add a javadoc with the URL to the
    hsqldb bug report/feature request/documentation for this, so we can
    track if this limitation is lifted and adjust Cayenne appropriately.

    Ari

    -------------------------->
    ish
    http://www.ish.com.au
    Level 1, 30 Wilson Street Newtown 2042 Australia
    phone +61 2 9550 5001 fax +61 2 9550 4001
    GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A



    This archive was generated by hypermail 2.0.0 : Tue Aug 12 2008 - 21:36:45 EDT