RE: Bug in UNIQUE?

2002-02-01 Thread J. Ceferino Ortega
uBois Asunto: Re: Bug in UNIQUE? In the last episode (Feb 01), Carsten Gehling said: > > >The SQL below illustrates what I believe is a bug in MySQL up to > > >and including 3.23.47. Essentially I need a unique key where one or > > >more of the component fields of

Re: Bug in UNIQUE?

2002-01-31 Thread Dan Nelson
In the last episode (Feb 01), Carsten Gehling said: > > >The SQL below illustrates what I believe is a bug in MySQL up to > > >and including 3.23.47. Essentially I need a unique key where one > > >or more of the component fields of the unique key can be NULL. > > >What seems to happen is that you

Re: Bug in UNIQUE?

2002-01-31 Thread Carsten Gehling
From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Jude Insley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Subject: Re: Bug in UNIQUE? > >The SQL below illustrates what I believe is a bug in MySQL up to and > >including 3.23.47. Essentially I need

Re: Bug in UNIQUE?

2002-01-31 Thread Paul DuBois
At 16:49 + 1/31/02, Jude Insley wrote: >Hi, > >The SQL below illustrates what I believe is a bug in MySQL up to and >including 3.23.47. Essentially I need a unique key where one or more of >the component fields of the unique key can be NULL. What seems to happen >is that you can add "duplicate