Views not generated correctly with generateChangelog

Description

When generating a changelog from an existing oracle database and the database contains a view the "CREATE VIEW" tag is generated, but when using the generated changelog to create a new database the oracle database throws the following error:

http://oraclequirks.blogspot.de/2007/10/ora-00998-must-name-this-expression.html

The SQL-statement to create the view looks like this:

CREATE VIEW VIEW1 (COLUMN1,COLUMN2,COLUMN3,COLUMN4)
AS SELECT a.COLUMN1,a.COLUMN2,a.COLUMN3,SUM(a.COLUMN4) FROM TABLE1 a GROUP BY a.COLUMN1,a.COLUMN2,a.COLUMN3;

The SQL-statement generated by liquibase differs from that:

CREATE VIEW VIEW1
AS SELECT a.COLUMN1,a.COLUMN2,a.COLUMN3,SUM(a.COLUMN4) FROM TABLE1 a GROUP BY a.COLUMN1,a.COLUMN2,a.COLUMN3;

So the column aliases are missing and Oracle throws an error message.

Environment

Oracle database

Reporter

Sascha Dechert

Fix versions

Affects versions

Priority

Blocker
Configure