[DDLUTILS-166] Column name 'language' causes errors during schema update

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Component/s: Core - PostgreSql
• Environment: PostgreSQL v8.2 on Windows XP
• Assignee: Thomas Dudziak
• Reporter: Stefan Huber
• Created: 21/Mar/07 15:10
• Updated: 21/Mar/07 22:30
• Resolved: 21/Mar/07 22:30

Description

Create a database with the following schema definition (I did this via an ant task)

<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="mydb">
<table name="ADDRESS">
<column name="ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="language" primaryKey="false" required="false" type="VARCHAR" size="256"/>
<index name="IDX_LANG">
<index-column name="language"/>
</index>
</table>
</database>

If you perform an schema update with the same definition you get an error, that the index column "language" could not be found in the table. Because of reasons I can only guess, the jdbs driver returns the index column name "language" in quotes so that the column is not found in the table definition.
This is a bit strange but even if the identifier "language" is a keyword in PostgreSQL it is allowed as a column name and DdlUtils should consider this too.