[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3591) MySQL check constraint and column comment are not generated in correct order

[Frank Zschage (JIRA)]

MySQL check constraint and column comment are not generated in correct order
----------------------------------------------------------------------------

                 Key: HHH-3591
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3591
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.1
         Environment: Hibernate Core 3.3.1 and Head Revision, MySQL 5.0, 5.1
            Reporter: Frank Zschage


In case of MySQL the column comment is part of the core column definition whereas the check constraint is part of the constraint definition and needs to be placed somewhere after the core column defintion. 

Hibernate creates the following syntax:
create table checktest ( 
    testcol varchar(5) not null check(...) comment '...', ... ) ...

MySQL requires the following syntax:
create table checktest ( 
    testcol varchar(5) not null comment '...' check(...), ... ) ...



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira