On Thu 2003-02-27 at 11:50:37 +0100, [EMAIL PROTECTED] wrote: > > We are in version freeze, however does some of you guys thinks this > version fixes bugs very important for your personal usage?
Most of the fixes seem to be for bugs that are not encountered that
often (judging from lack of repeating reports on the main discussion
and the bug mailing lists). But there is one major change that may be
of interest:
* `NULL' is now sorted *LAST* if you use `ORDER BY ... DESC' (as it
was before before MySQL 4.0.2). This is change was required to
follow ANSI SQL 99. (The original change was because we thought
that ANSI SQL 99 required NULL to be always sorted at the same
position, but this was wrong).
That is, only with 4.0.11 MySQL adheres to the SQL standard the same
as 3.23 in this regard. On the other hand, the whole MySQL beta cycle
passed until someone bothered to complain, so maybe that is not used
as much either.
For me, 4.0.10 works fine. On the other hand, with 4.0.6 the 4.0 cycle
has gone gamma status and in bug-squashing mode. So maybe 4.0.11
should be applied simply because it has to be considered mainly a
bug-fix release?
HTH,
Benjamin.
pgp00000.pgp
Description: PGP signature
