Hello,
Column names are behaving very strangely. In queries, all names are
converted to lowercase.
Example:
I have a table named "LOCATION".
select * from location;
I get an error message (this is OK)
select * from LOCATION;
I get an error message (this is NOT OK)
select * from "location";
I get an error message (this is OK)
select * from "LOCATION";
Everything works (this is OK)
Is it by design? I think that database shouldn't convert name case in SQL
statements, or it should try to make case-insensitive match (like
Interbase) if double quotes are not used.