Case sensitivity issue with tableExists precondition

Description

From http://forum.liquibase.org/topic/lb-3-0-7-against-mssql-precondition-tableexists-not-handled#49382000000941021

we have tested LB 3.0.7 (using Ant 1.8.2) with our scripts (in order to upgrade from LB 2.0.1) against MSSQL 2008 R2 (v10.50.4000.0) and found following error:

Error executing SQL CREATE TABLE [dbo].[Table] ([Column1] VARCHAR(50) NOT NULL, [Column2] BIGINT NOT NULL, [Column3] BIGINT NOT NULL, CONSTRAINT [PK_Table] PRIMARY KEY ([Column1])); This table already exists.
This error should have been handled in our scripts by the following expression:
<preConditions onFail="error_handling">
<not>
<tableExists schemaName="${liquibase.meta.schema}" tableName="Table"/>
</not>
</preConditions>

So it seems the precondition tableExists doesnt work with LB 3.0.7 in this case.
The scripts work fine with LB 2.0.1.

------------

I am running into this same problem with Oracle. When I changed the property to be the schema name in all caps, it works correctly. I compared to 2.0.5, and I did not need the schema name to be in all caps.

Environment

MSSQL, Oracle

Status

Reporter

Nathan Voxland

Fix versions

Affects versions

Priority

Major
Configure