Subject Re: [firebird-support] Upper case behaviour
Author Eugen.Konkov@aldec.com
>Martijn Tonies
>So you end up with 1 column of table names with values like:

>MyTABLE
>MYTABLE
>MyTAble

>These are 3 different tables, obviously, MYTABLE can be used unquoted
>(all uppercase), and the other ones need to be quoted. Why? Because they
>contain mixed case identifiers.

AS I ALLOW same names in database like 'aa' and 'aA'
I MUST be responsible for that and must use quoting
select * from "aa";
select * from "aA";

so queries
select * from MyTABLE;
select * from MYTABLE;
select * from MyTAble;
must result SQL ERROR: ambigious object name 'MyTABLE'/'MYTABLE'/'MyTAble'


[Non-text portions of this message have been removed]