[
http://jira.codehaus.org/browse/MSQL-57?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Scholte closed MSQL-57.
------------------------------
Resolution: Not A Bug
Assignee: Robert Scholte
Thanks Johan for figuring this out. I've done some extra googling for {{errnr:
150}}, found enough hits. It seems like both columns have to be EXACLTY the
same. And that looks like the problem, since int(11) is not the same as INTEGER.
On way or another, it's not a sql-m-p bug, there's really nothing we can do
about it.
> 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
> Assignee: Robert Scholte
> Priority: Critical
> Attachments: sqltest.zip, test-result-5.1.48.txt,
> test-result-5.5.3-m3.txt
>
>
> 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
