Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB? - Mailing list pgsql-general

From Vivek Khera
Subject Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB?
Date
Msg-id E84AE31F-E54D-4FB4-A0A4-5C7F0C97BA02@khera.org
Whole thread Raw
In response to NULLs in unique indexes; Was: Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB?  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
On Feb 16, 2006, at 6:27 AM, Alban Hertroys wrote:

> Vivek Khera wrote:
>> http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
>> I especially like the third restriction.  How on earth do people
>> live  with this software?
>
> That's the part where they allow only one NULL value in a unique
> index, right? Opinions seem to differ on this matter...

Ok, fair enough... but you still get different behavior depending on
your table type in mysql, which is just idiotic...  At least with
every other system, you get what you get all the time, not just some
of the time.


pgsql-general by date:

Previous
From: Reid Thompson
Date:
Subject: Re: Oracle tried to buy MySQL
Next
From: Tom Lane
Date:
Subject: Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB?