Do you mean that in Oracle your original scenario will work? create table "$Test"(...); insert into "$test" ...
I really doubt. In Oracle docs it is clearly stated that "Nonquoted identifiers are not case sensitive. Oracle interprets them as uppercase. Quoted identifiers are case sensitive." http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm As for ANSI here is a respective quote from SQL-92 stating that comparison of two double quoted identifiers must be case sensitive: 14)Two <delimited identifier>s are equivalent if their <delimited identifier body>s (with all occurrences of <quote> replaced by <quote symbol> and all occurrences of <doublequote symbol> replaced by <doublequote>), considered as the repetition of a <character string literal> that specifies a <character set spec- ification> of SQL_TEXT and an implementation-defined collation that is sensitive to case, compare equally according to the comparison rules in Subclause 8.2, "<comparison predicate>". http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Sergi 2016-03-10 22:57 GMT+03:00 Aleksey Konstantinov <[email protected]>: > I did verification of the behavior in the "style" of Oracle: > CREATE TABLE test (id int NOT NULL); > -- ok > > CREATE TABLE "TEST" (id int NOT NULL); > -- Error: Table "TEST" already exists; SQL statement: CREATE TABLE "TEST" > (id int NOT NULL) [42101-191] > > It seems to me that such an ambiguous interpretation of the name objects > and still is a bug. > > P.S. Naming double quotes in Oracle is not a standard ANSI SQL :) Most > database says that using national or other characters in the naming > required to enter the object name in double quotes. But this does not mean > a case-sensitive naming the object. > > -- > 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.
