ALTER TABLE instructions not commented out in DDL when using mySQL
------------------------------------------------------------------
Key: MAVEN-40
URL: http://jira.andromda.org/browse/MAVEN-40
Project: Maven Plugins
Type: Bug
Components: APP
Versions: 3.1-RC1
Environment: mySQL
Reporter: Joel Kozikowski
Assigned to: Chad Brandon
Priority: Minor
In a project generated with andromdapp:generate, the generated file
core/maven.xml contains the following code:
<ant:replaceregexp file="${hibernate.schema.output.dir}/schema-create.sql"
match="^(alter table .* drop constraint|drop table)"
replace="-- SKIP \1"
flags="i"
byline="true"/>
The purpose of this code is to comment out lines of the DDL that may cause
error messages when installing the DDL using the create-schema goal. The above
fails for mySQL, as the relevent contraints are defined with "DROP FOREIGN KEY"
instead of "DROP CONSTRAINT".
The second line should read:
match="^(alter table .* drop constraint|alter table .* drop
foreign key|drop table)"
to allow for the mySQL lines "ALTER TABLE .* drop foreign key" to be included
in the code that is commented out in the resulting schema DDL.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.andromda.org/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by HP,
AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar
_______________________________________________
Andromda-devel mailing list
Andromda-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/andromda-devel
