[ http://issues.apache.org/jira/browse/DDLUTILS-55?page=all ]
Thomas Dudziak updated DDLUTILS-55:
-----------------------------------
Component: Core - HSQLDB
> HsqlDb PlatformInfo should not use delimited identifiers
> --------------------------------------------------------
>
> Key: DDLUTILS-55
> URL: http://issues.apache.org/jira/browse/DDLUTILS-55
> Project: DdlUtils
> Type: Bug
> Components: Core - HSQLDB
> Reporter: Ken Weiner
> Assignee: 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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
