Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1095

Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception.

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.0
    • 3.0M5
    • Core Library
    • None
    • os x, hsqldb 1.8.0.10, java 1.5

    Description

      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);

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            nirvdrum Kevin Menard
            ongakugainochi Robert Zeigler
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment