diffDatabaseToChangeLog / updateDatabase tries to update table in Reference database

Description

When creating a sql file to update a database with an older version I am having problems with Foreign Keys. I expect liquibase to correct any errors / problems / differences in the database I specify, but it keeps adding entries to update my Reference database:

ALTER TABLE `reference_db`.`table` ADD CONSTRAINT `FK_ght3cbd158a0kf1fq19b6mlml` FOREIGN KEY (`id`) REFERENCES `reference_db`.`base` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION;

ALTER TABLE `reference_db`.`table` ADD CONSTRAINT `FK_s4xwdnbr0x3ga73ljhxb2jllm` FOREIGN KEY (`parent_id`) REFERENCES `reference_db`.`base` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION;

Instead of these entries I would expect that the keys in the database I try to update are adapted to be the same like in the reference database (which is built from scratch only to make the comparison).

I tried updating to liquibase 3.1.1, but besides other problems () that make it unusable for the time being, the problem persists in the latest version.

Environment

Mysql Server Version: 5.1.41
Hibernate 4.3.4

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created May 16, 2014 at 12:04 PM
Updated May 16, 2014 at 12:08 PM