H.Merijn Brand wrote on 05/09/09 10:10:
Can someone show me the case specifications for SQL?
I think that unless quoted table names are case insensitive, so
SELECT * FROM FOO;
equals
select * from foo;
but does not equal
SELECT * from "Foo";
What you describe matches DB2 and Oracle behavior and, based on what Jonathan
says in his email, the SQL standard.
IMHO, when selecting from files, unquoted table names should match
case-insensitive, so a file named "Foo" should match all three, but
file named "foo" should match the first two statements.
If I am right, I got the unquoted working in my current DBD::File,
and I'm working on the second part (it currently matches too often)
