[
http://jira.codehaus.org/browse/MSQL-57?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=226129#action_226129
]
Eugene Dzhurinsky commented on MSQL-57:
---------------------------------------
Can you please try it out with MySQL 5.1 and 5.5 ?
> Tables with foreign keys can not be imported into MySQL
> -------------------------------------------------------
>
> Key: MSQL-57
> URL: http://jira.codehaus.org/browse/MSQL-57
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.4
> Environment: java version "1.6.0_03-p4"
> Java(TM) SE Runtime Environment (build 1.6.0_03-p4-root_20_dec_2008_19_46-b00)
> Java HotSpot(TM) Server VM (build 1.6.0_03-p4-root_20_dec_2008_19_46-b00,
> mixed mode)
> mvn -v
> Apache Maven 2.2.1 (r801777; 2009-08-06 19:16:01+0000)
> Java version: 1.6.0_03-p4
> Java home: /usr/local/jdk1.6.0/jre
> Default locale: en_US, platform encoding: UTF-8
> OS name: "freebsd" version: "7.3-stable" arch: "i386" Family: "unix"
> mysql -V
> mysql Ver 14.14 Distrib 5.5.4-m3, for portbld-freebsd7.3 (i386) using 5.2
> Reporter: Eugene Dzhurinsky
> Priority: Critical
> Attachments: sqltest.zip
>
>
> I am trying to create a database with tables, having foreign keys attached to
> them. Unfortunately I am getting strange error:
> Can't create table 'testdb.configuration' (errno: 150)
> from maven. The same SQL file, if imported into MySQL with command-line
> client, gets imported without any error.
> If you remove foreign key declaration - tables will be created without any
> error.
> I attached the package with sample Maven project.
> Thank you in advance!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
