sql - 关闭 HSQL 中表名和列名的大写？

Question

如何关闭 HSQL 中表名和列名的强制大写模式？

<artifactId>hsqldb</artifactId>
<version>2.3.1</version>

操作系统: Windows 7 x64

Answer 1

HSQLDB documentation 中解释了有关此问题的规则。 :

When a database object is created with one of the CREATE statements or renamed with the ALTER statement, if the name is enclosed in double quotes, the exact name is used as the case-normal form. But if it is not enclosed in double quotes, the name is converted to uppercase and this uppercase version is stored in the database as the case-normal form.

Case sensitivity rules for identifiers can be described simply as follows:

• all parts of SQL statements are converted to upper case before processing, except identifiers in double quotes and strings in single quotes
• identifiers, both unquoted and double quoted, are then treated as case-sensitive
• most database engines follow the same rule, except, in some respects, MySQL and MS SQLServer.

AFAIK 无法关闭此行为。 (值得注意的是，当不使用带引号的标识符时，标准 SQL 不区分大小写。)但如上所述，可以通过用引号括起来来指定小写标识符，例如:

CREATE TABLE "lowercasetablename" ("lowercasecolname" INT);
SELECT "lowercasecolname" FROM "lowercasetablename";