Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
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');