openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <>
Subject [jira] Created: (OPENJPA-455) Incorrect MySQL DDL Generation for integer types
Date Tue, 27 Nov 2007 23:44:43 GMT
Incorrect MySQL DDL Generation for integer types

                 Key: OPENJPA-455
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 1.0.1, 1.0.0
            Reporter: Michael Dick

Opening a JIRA report on Tim's behalf. 

I turned the schema tool loose on a MySQL production database this
afternoon and it failed. The essence of the problem appears that DDL was
being generated with a type declaration of this form:

int unsigned(10)

In MySQL, the proper form is:

int(10) unsigned


ALTER TABLE fubar MODIFY col1 int(10) unsigned;

Checking other options indicates that similar constructs such as CREATE
TABLE are likewise defective.

I looked at the svn trunk head source code in and the parent class The offending method appears to be:

1508:     public String getTypeName(Column col)

This method has no override in MySQLDictionary, but apparently needs
one. I think it's a minor mod, but I'm not currently set up to build and
test in the environment where the offending database exists.

This is a SEVERE error. It causes generation of defective SQL for
SQL-generating options and causes live updates to schemas to fail.

I don't have a Jira login at present, so if someone could log this, it
would be appreciated.


   Tim Holloway

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message