You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Stefan Huber (JIRA)" <ji...@apache.org> on 2007/03/21 16:12:32 UTC
[jira] Created: (DDLUTILS-166) Column name 'language' causes errors
during schema update
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.
[jira] Resolved: (DDLUTILS-166) Column name 'language' causes
errors during schema update
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ 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.