]
Frank Zschage commented on HHH-3591:
------------------------------------
The Hibernate syntax creates an error and ist not executable.
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: