db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ken Weiner (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-55) HsqlDb PlatformInfo should not use delimited identifiers
Date Tue, 20 Dec 2005 06:25:30 GMT
HsqlDb PlatformInfo should not use delimited identifiers 

         Key: DDLUTILS-55
         URL: http://issues.apache.org/jira/browse/DDLUTILS-55
     Project: DdlUtils
        Type: Bug
    Reporter: Ken Weiner
 Assigned to: Thomas Dudziak 
 Attachments: HsqlDbPlatform-patch.txt

Currently, when creating tables using HSQLDB, double quotes (") are used surrounding the table
names in each CREATE TABLE statement.  For example,

CREATE TABLE "person" ...

As a result, it isn't possible to write SQL without putting double quotes around tables names.
 For example, this statement doesn't work:

select * from person;

But this one does:

select * from "person";

If useDelimitedIdentifiers in PlatformInfo is set to false, then double quotes will not surround
the table names in CREATE TABLE statements and then SQL statements will work as expected (without
having to include the double quotes).

I will attach a patch for this simple change.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message