[DDLUTILS-55] HsqlDb PlatformInfo should not use delimited identifiers

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Component/s: Core - HSQLDB
• Assignee: Thomas Dudziak
• Reporter: Ken Weiner
• Created: 20/Dec/05 15:23
• Updated: 13/Jul/06 14:35
• Resolved: 20/Dec/05 17:06

Description

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.