Skip to:
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::stijnvermeerenALTER 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::stijnvermeerenINSERT 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');
OSX, Oracle XE, Liquibase 3.2.3-SNAPSHOT
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');