Testing on created databases with IGNORECASE=TRUE and IGNORECASE=FALSE
-- use "$" char in table name:
CREATE TABLE public."$Test_Chars" (
id int NOT NULL
);
-- working:
INSERT INTO public."$Test_Chars" (id) VALUES(1);
-- does not work:
INSERT INTO public."$test_chars" (id) VALUES(1);
Error: Table "$test_chars" not found; SQL statement:
Also, does not correctly work JDBC driver when working with metadata:
ResultSet rs = connection.metaData.getTables(null, "PUBLIC", null, null);
while (rs.next()) {
System.out.println(rs.getString("TABLE_NAME"));
}
rs.close();
All the names of the tables from the scheme returned in upper case. But
table $Test_Chars return as "$Test_Chars".
For IGNORECASE=TRUE all database object names are in uppercase, but table
name $Test_Chars is not changed to uppercase in mv db file.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
