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
