H2 seems to make a difference between name with quote and name without quote. Is there a way to make it treat them the same way?
Here's the tests that I've done :
CREATE TABLE test (dummy INT);
CREATE TABLE "testquote" (dummy INT, "quotedDummy" INT);
Here are the queries :
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
What can I do to make those queries work with H2?
See Question&Answers more detail:os