dropAllForeignKeyConstraints doesn't work with oracle

Description

dropAllForeignKeyConstraints doesn't work with oracle. The updateSQL command does not generate any ALTER TABLE statements just "SET DEFINE OFF;".

output of same changeset for mysql and oracle.

MySQL (working):

– Lock Database
– Changeset db/changelog.201406241143-2175-genius-increments.xml::2175-genius-increments-drop-fk::stijnvermeeren
ALTER TABLE `app_development`.`user_has_tag` DROP FOREIGN KEY `fk_uhtti`;

ALTER TABLE `app_development`.`user_has_tag` DROP FOREIGN KEY `fk_uhtui`;

INSERT INTO app_development.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('2175-genius-increments-drop-fk', 'stijnvermeeren', 'db/changelog.201406241143-2175-genius-increments.xml', NOW(), 507, '7:7c637a565758106c7861ded7b97774d7', 'dropAllForeignKeyConstraints', '', 'EXECUTED', '3.2.3-SNP');

Oracle:

SET DEFINE OFF;

– Lock Database
– Changeset db/changelog.201406241143-2175-genius-increments.xml::2175-genius-increments-drop-fk::stijnvermeeren
INSERT INTO APP_DATA.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('2175-genius-increments-drop-fk', 'stijnvermeeren', 'db/changelog.201406241143-2175-genius-increments.xml', SYSTIMESTAMP, 602, '7:7c637a565758106c7861ded7b97774d7', 'dropAllForeignKeyConstraints', '', 'EXECUTED', '3.2.3-SNP');

Environment

OSX, Oracle XE, Liquibase 3.2.3-SNAPSHOT

Activity

Show:

Details

Reporter

Affects versions

Priority

Created September 18, 2014 at 8:52 AM
Updated September 18, 2014 at 8:52 AM
Loading...