Tables created with wrong case in diff

General Discussion
1

Hi

I’m performing a diff on a remote mysql database, and finding that the changeset that is generated uses the incorrect casing for table names (all lowercase).  This subsequently causes the update to fail.

Liquibase v1.9.5
Database : MySQL
Local OS: Windows 7
Remote OS: Ubuntu

Am I doing something wrong, or is this a bug?

Here’s my diff task:

    <diffDatabaseToChangeLog driver="${database.driver}" url="${production.database.url}" username="${production.database.username}" password="${production.database.password}" 
    		baseUrl="${database.url}" 
		baseUsername="${database.username}" 
		basePassword="${database.password}" 
		outputFile="${changeLogFile}" classpathref="liquibase-path">
	</diffDatabaseToChangeLog>
</target>

Regards

Marty

2

It appears to be a bug.  There are places that we lower case table names to work correctly with case insensitive databases, but then it causes problems with case sensitive databases. 

Improvements to the diff tool are scheduled for LiquiBase 2.1.

Nathan