Generating a change log with multiple columns foreign keys from an existing Oracle database fails

General Discussion
1

Hi,

I am trying to generate a changelog from our existing database. Couple of the tables have foreign keys that contain multiple columns. It seems this does not work, as the generated addForeignKeyConstraints does not contain comma separated baseColumnNames nor referencedColumnNames. Only the first column of the foreign key is contained.

I use Liquibase 3.0.2. Is that supposed to work? Does it work for someone? Anything I could have done wrong?

liquibase --defaultCatalogName= --classpath=… --driver=oracle.jdbc.OracleDriver --changeLogFile=… --url jdbc:oracle:thin:@…:1521:develop --username=USER_2 --password=…  generateChangeLog

(… = Removed for privacy reasons)

TIA,

Sascha

2

Same problem here with version 3.0.2.

Tibi

3

I think I found a problem with how foreign keys are compared. The fix will be in 3.0.3, hopefully out soon.


Nathan

4

Thanks Nathan. Looking forward to 3.0.3.

Sascha

5

Any news about the release date of 3.0.3?

6

Working to finish it up soon. It’s been a couple busy weeks of traveling, but hopefully by the beginning of next week at the latest.


Nathan

7

Thumbs up!

Sascha

8

It seems this is not yet fixed in 3.0.4. Multi column foreign keys are not generated correctly when running generateChangelog against Firebird and Oracle database. Shouldn’t that be fixed?

9

I am going to create one and add it as a comment to the Jira entry.

10

It should be fixed, I’ll have to take a look. If you have an easy test case you can send that would be great.


Nathan

11

I created https://liquibase.jira.com/browse/CORE-1453 to track the issue in 3.0.4


Nathan