ORACLE: Check for existing tables is case sensitive
We use custom databaseChangeLogTableName(s) which are specified as a lower case string. This worked fine with Liquibase 2.0.3, but after upgrading to Liquibase 3.0.2 fails for ORACLE.
I debugged the issue and found that the TableSnapshotGenerator.snapshotObject does not handle the case insensitivity of ORACLEs table names and therefore fails to detect the already existing table. This leads to the following exception:
liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE MYSCHEMA.myprefix_changelog ( [ ...] ): ORA-00955: name is already used by an existing object
Might this be an issue for other use cases, too?
Fixed in 3.0.5