]
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: