Subject | Re: [firebird-support] Upper case behaviour |
---|---|
Author | Eugen.Konkov@aldec.com |
Post date | 2007-12-05T11:30:03Z |
>Martijn ToniesAS I ALLOW same names in database like 'aa' and 'aA'
>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.
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]