You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Milosz Tylenda (JIRA)" <ji...@apache.org> on 2009/06/13 17:07:07 UTC

[jira] Resolved: (OPENJPA-1132) Dropping constraints fails on MySQL

     [ https://issues.apache.org/jira/browse/OPENJPA-1132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Milosz Tylenda resolved OPENJPA-1132.
-------------------------------------

       Resolution: Fixed
    Fix Version/s: 2.0.0
                   1.3.0

I have modified MySQLDictionary to use "ALTER TABLE xxx DROP FOREIGN KEY yyy". Also corrected the statement to drop a primary key to "ALTER TABLE xxx DROP PRIMARY KEY" although it seems to be unused at the moment.

Change applied to trunk and 1.3.x branch.


> Dropping constraints fails on MySQL
> -----------------------------------
>
>                 Key: OPENJPA-1132
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1132
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.3.0, 2.0.0
>         Environment: MySQL 5.1
>            Reporter: Milosz Tylenda
>            Assignee: Milosz Tylenda
>             Fix For: 1.3.0, 2.0.0
>
>
> MySQL rejects our DROP CONSTRAINT statements, it requires different syntax.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.