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

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB?
Date: 2006-02-16 15:10:36
Message-ID: E84AE31F-E54D-4FB4-A0A4-5C7F0C97BA02@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-16 15:33:44 Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB?
Previous Message Reid Thompson 2006-02-16 15:07:00 Re: Oracle tried to buy MySQL