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

[Frank Zschage (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Frank Zschage updated HHH-3591:
-------------------------------

    Attachment: checktest.tar.gz

> 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
>         Attachments: checktest.tar.gz
>
>
> 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