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

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.