db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DDLUTILS-166) Column name 'language' causes errors during schema update
Date Wed, 21 Mar 2007 22:30:32 GMT

     [ 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.

View raw message