When you use double quoted identifiers they are always case sensitive. It is ANSI SQL standard and there is nothing wrong with H2. Oracle will work the same way.
Sergi 2016-03-10 17:25 GMT+03:00 Aleksey Konstantinov <[email protected]>: > 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. > -- 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.
