hsqldb, doubles, and precision

From: Robert Zeigler (robert.zeigle..mail.com)
Date: Tue Aug 12 2008 - 21:02:21 EDT

  • Next message: Aristedes Maniatis: "Re: hsqldb, doubles, and precision"

    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.

    Robert

    This archive was generated by hypermail 2.0.0 : Tue Aug 12 2008 - 21:03:59 EDT