Subject Re: [firebird-support] Bug: Index on "Name" incorrectly indexes on "NAME"
Author Aage Johansen
Martijn Tonies wrote:
> Hello Raymond,
> ...
> All that being said, you will slap yourself in the head a couple
> of times with field names like:
>
> "Name" and NAME both in the same table.
>
> If not, your boss should do that.
>

If NAME is just an uppercase shadow of "Name" it makes sense! Maybe too
clever - one easily trips over things like this.

--
Aage J.


>
>
>>
>>CREATE TABLE "Customer" (
>> ID D_GENERATOR /* D_GENERATOR = INTEGER NOT NULL */,
>> "Name" D_NAME_C /* D_NAME_C = VARCHAR(50) NOT NULL */,
>> NAME D_NAME /* D_NAME = VARCHAR(50) NOT NULL */,
>> "Email" D_EMAIL /* D_EMAIL = VARCHAR(50) */
>>);
>>