Doh! Blindsided by an Oracle DBA, the only spec I could get my hands on
is an old draft thing and I have to admit from that it looks like the
correct behaviour.. NULL <> NULL and all that..
Thanks,
Jon
On Tue, 18 Jun 2002 10:54:15 -0500
Gerald Clark <[EMAIL PROTECTED]> wrote:
> That is correct
That is correct.
Use NOT NULL in the definition to force unique keys.
[EMAIL PROTECTED] wrote:
>>Description:
>>
> If a null column is used in a unique index then mysql fails to throw a
> key violation when multiple identical inserts (with nulls) are
> performed.
>
>>How-To-Repeat:
>>
> create
