We're updating the issue view to help you get more done. 

Offline database does not escape keywords

Description

When running updateSQL using an offline url, keywords are not escaped. It seems Liquibase gets these keywords by querying the JDBC driver. (See liquibase.database.core.OracleDatabase.setConnection(DatabaseConnection) around line 117.) In offline mode, this code is skipped.

The result is a query like:
CREATE TABLE MYTABLE (ID NUMBER(19, 0) NOT NULL, DATE date NOT NULL, CONSTRAINT PK_MYTABLE PRIMARY KEY (ID));

While it should be:
CREATE TABLE MYTABLE (ID NUMBER(19, 0) NOT NULL, "DATE" date NOT NUL, CONSTRAINT PK_MYTABLE PRIMARY KEY (ID));

Environment

Oracle 11.2, using url: offline:oracle?version=11.2.0.2.0

Status

Assignee

Unassigned

Reporter

Jurrie

Labels

None

Components

Affects versions

3.6.3

Priority

Major