"mvn liquibase:diff" does not find any differences between databases

Description

Since the fix for issue was introduced in Liquibase 3.2.1, diffing databases using Liquibase Maven Plugin always gives empty result, even when there actually are differences between databases.

For example, I have two databases, one which contains a table named "DUMMY", one which doesn't. When I run "mvn liquibase:diff" using Liquibase Maven Plugin 3.1.1, I get the following correct result:

Diff Results:
Reference Database: SA @ jdbc:h2:~/tmp/sampledb/sampledb (Default Schema: PUBLIC)
Comparison Database: SA @ jdbc:h2:~/.sampledb/sampledb (Default Schema: PUBLIC)
Product Name: EQUAL
Product Version: EQUAL
Missing Catalog(s): NONE
Unexpected Catalog(s): NONE
Changed Catalog(s): NONE
Missing Column(s):
DUMMY.ID
DUMMY.NAME
DUMMY.VALUE
Unexpected Column(s): NONE
Changed Column(s): NONE
Missing Foreign Key(s): NONE
Unexpected Foreign Key(s): NONE
Changed Foreign Key(s): NONE
Missing Index(s):
PRIMARY_KEY_3 on DUMMY(ID)
Unexpected Index(s): NONE
Changed Index(s): NONE
Missing Primary Key(s):
DUMMYPK on DUMMY(ID)
Unexpected Primary Key(s): NONE
Changed Primary Key(s): NONE
Missing Schema(s): NONE
Unexpected Schema(s): NONE
Changed Schema(s): NONE
Missing Sequence(s): NONE
Unexpected Sequence(s): NONE
Changed Sequence(s): NONE
Missing Stored Procedure(s): NONE
Unexpected Stored Procedure(s): NONE
Changed Stored Procedure(s): NONE
Missing Table(s):
DUMMY
Unexpected Table(s): NONE
Changed Table(s): NONE
Missing Unique Constraint(s): NONE
Unexpected Unique Constraint(s): NONE
Changed Unique Constraint(s): NONE
Missing View(s): NONE
Unexpected View(s): NONE
Changed View(s): NONE

When I change Liquibase Maven Plugin version to 3.2.1 or 3.2.2, I get this incorrect result:

Diff Results:
Reference Database: SA @ jdbc:h2:~/tmp/sampledb/sampledb (Default Schema: PUBLIC)
Comparison Database: SA @ jdbc:h2:~/.sampledb/sampledb (Default Schema: PUBLIC)
Product Name: EQUAL
Product Version: EQUAL
Missing Catalog(s): NONE
Unexpected Catalog(s): NONE
Changed Catalog(s): NONE
Missing Column(s): NONE
Unexpected Column(s): NONE
Changed Column(s): NONE
Missing Foreign Key(s): NONE
Unexpected Foreign Key(s): NONE
Changed Foreign Key(s): NONE
Missing Index(s): NONE
Unexpected Index(s): NONE
Changed Index(s): NONE
Missing Primary Key(s): NONE
Unexpected Primary Key(s): NONE
Changed Primary Key(s): NONE
Missing Schema(s): NONE
Unexpected Schema(s): NONE
Changed Schema(s): NONE
Missing Sequence(s): NONE
Unexpected Sequence(s): NONE
Changed Sequence(s): NONE
Missing Stored Procedure(s): NONE
Unexpected Stored Procedure(s): NONE
Changed Stored Procedure(s): NONE
Missing Table(s): NONE
Unexpected Table(s): NONE
Changed Table(s): NONE
Missing Unique Constraint(s): NONE
Unexpected Unique Constraint(s): NONE
Changed Unique Constraint(s): NONE
Missing View(s): NONE
Unexpected View(s): NONE
Changed View(s): NONE

Environment

Apache Maven 3.0.4 (r1232337; 2012-01-17 09:44:56+0100)
Maven home: C:\install\apache-maven-3.0.4-bin\apache-maven-3.0.4
Java version: 1.7.0_45, vendor: Oracle Corporation
Java home: C:\Program Files\Java\jdk1.7.0_45\jre
Default locale: pl_PL, platform encoding: Cp1250
OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows"

Activity

Show:

Nathan Voxland November 10, 2014 at 8:58 PM

Great, thanks for the update

Former user November 7, 2014 at 9:59 AM

Thanks a lot, it works fine.

Nathan Voxland November 7, 2014 at 2:35 AM

Sorry, forgot the second button press in the release process on sonatype. It 3.2.3 should be up there now.

KonstantinosP November 7, 2014 at 12:11 AM

Thanks for the release Nathan. It seems that 3.3.0 has been pushed to OSS but not 3.2.3.
Would it be possible to push this one as well?

Nathan Voxland November 6, 2014 at 8:26 PM

It sometimes takes a couple days to work through the maven mirror system. I uploaded it to oss.sonatype.org and it should get mirrored from there.

Fixed

Details

Reporter

Fix versions

Affects versions

Priority

Created July 25, 2014 at 10:18 AM
Updated November 10, 2014 at 8:58 PM
Resolved September 23, 2014 at 6:58 PM