H2似乎区分带引号和不带引号的名称。有没有办法让它以相同的方式处理它们?
这是我做过的测试:
CREATE TABLE test (dummy INT);
CREATE TABLE "testquote" (dummy INT, "quotedDummy" INT);
以下是查询语句:
SELECT * FROM test; --work
SELECT * FROM "test"; -- doesn't work
SELECT * FROM "testquote"; --work
SELECT * FROM testquote; --doesn't work
SELECT dummy FROM "testquote"; --work
SELECT quotedDummy FROM "testquote"; --doesn't work
SELECT "quotedDummy" FROM "testquote"; --work
我该如何使这些查询与H2兼容?
UPPERCASE
在 H2 上能用吗?在 H2 的 SQL 文档中找不到它。 - Drahakar