Subject | Re: [firebird-support] Bug: Index on "Name" incorrectly indexes on "NAME" |
---|---|
Author | Aage Johansen |
Post date | 2004-11-27T17:50:27Z |
Martijn Tonies wrote:
clever - one easily trips over things like this.
--
Aage J.
> Hello Raymond,If NAME is just an uppercase shadow of "Name" it makes sense! Maybe too
> ...
> 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.
>
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) */
>>);
>>