[
https://issues.apache.org/jira/browse/DDLUTILS-166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Dudziak resolved DDLUTILS-166.
-------------------------------------
Resolution: Won't Fix
What words are allowed is totally up to the database (and actually might even
differ between different revisions of the same database product). And we simply
don't have the tremendous amount of time necessary to hunt for the lists of
not-allowed words for all databases and their revisions that DdlUtils supports.
Also, if you want to use reserved words, simply use delimited identifier mode
in which you can even use words like select and from for e.g. table names
without a problem.
> 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.
