Column name 'language' causes errors during schema update
---------------------------------------------------------
Key: DDLUTILS-166
URL: https://issues.apache.org/jira/browse/DDLUTILS-166
Project: DdlUtils
Issue Type: Bug
Components: Core - PostgreSql
Environment: PostgreSQL v8.2 on Windows XP
Reporter: Stefan Huber
Assigned To: Thomas Dudziak
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
