Orcale: Liquibase doesn't escape reserved-words-column with quotes.

Description

A column named 'number' (reserved word in Oracle) is not escaped by Liquibase. This causes ORA-00904: invalid identifier.
Generated SQL:

CREATE TABLE document (id NUMBER(38,0) NOT NULL, number INTEGER NOT NULL, CONSTRAINT PK_DOCUMENT PRIMARY KEY (id))

I belive that this changeset is reason for not escaping.

Environment

grails database-migration plugin

Activity

Show:

Nathan Voxland March 20, 2012 at 6:22 PM

I'll add the derby reserved words back in. It is configurable per Database class, but needs better defaults

Caspar MacRae March 19, 2012 at 10:50 AM
Edited

Could/Should be made configurable?

Otherwise, reserved words failing for Derby: "user", "group"

(version: 2.0.3)

Nathan Voxland September 11, 2011 at 6:09 AM

added "number" back as reserved word

Fixed

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created September 2, 2011 at 2:51 PM
Updated June 20, 2013 at 3:31 AM
Resolved April 14, 2012 at 6:24 AM

Flag notifications