[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4454) Foreign Key constraints duplicated when dbCreate='update' is set in Grails

[Fabrizio D'Ammassa (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=34011#action_34011 ] 

Fabrizio D'Ammassa commented on HHH-4454:
-----------------------------------------

I forgot to mention some details on the configuration to run the test case.
I'm using Grails 1.1.1, MySql 5.0.41 on a Mac but the I have experienced the problem also on Linux environment. The Hibernate version used by Grails is Hibernate 3-3.3.1.

Let me know if you need more details.

Thanks

Fabrizio



> Foreign Key constraints duplicated when dbCreate='update' is set in Grails
> --------------------------------------------------------------------------
>
>                 Key: HHH-4454
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4454
>             Project: Hibernate Core
>          Issue Type: Bug
>         Environment: Linux, Mac
>            Reporter: Fabrizio D'Ammassa
>         Attachments: testFK.tar.gz
>
>
> If I create a foreign key constraint manually with and sql query and then I run grails with 'dbCreate=update' set, it will create another foreign key constraint.
> In the attached application you can find a sql folder with the schema.sql file you have to run on your mysql server. You have to change the datasource params (dbname, dbhost, dbuser, dbpassword) but leave the dbCreate option set to 'update' to reproduce the bug.
> After the first grails run-app you should see a duplicate constraint on your db schema (if for example you can try to export your db schema with phpmyadmin).
> Thanks
> Fabrizio

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