[ http://issues.apache.org/jira/browse/DDLUTILS-55?page=comments#action_12360899 ]
Ken Weiner commented on DDLUTILS-55: ------------------------------------ Thanks again. I have things working now after changing the flag to not use delimited identifiers. I am surprised that the default setting is to use them since I rarely have seen programs that generate SQL with the identifiers delimited. I imagine this could easily confuse others as well. > 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 > 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