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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
