End of Product LifecycleActive development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Fixed problem that affected queries that did arithmetic on group functions.
Fixed problem with timestamps and
date_col BETWEEN const_date AND
Fixed problem when only changing a 0 to
NULL in a table with
Fixed bug in range optimizer when using many key parts and or
on the middle key parts:
WHERE K1=1 and K3=2 and
(K2=2 and K4=4 or K2=3 and K4=5)
Fixed critical problem with the
Do not give an unnecessary
GRANT error when using tables
from many databases in the same query.
Added VIO wrapper (needed for SSL support; by Andrei Errapart and Tõnu Samuel).
Fixed optimizer problem on
SELECT when using many
overlapping indexes. MySQL should now be able to choose keys
even better when there are many keys to choose from.
Changed optimizer to prefer a range key instead of a ref key
when the range key can uses more columns than the ref key
(which only can use columns with
example, the following type of queries should now be faster:
SELECT * from key_part_1=const and key_part_2 >
Disabled floating-point exceptions for FreeBSD to fix core
dump when doing
HEAP tables. This should fix all problems
HEAP tables when using
Added option to print default arguments to all clients.
Fixed core dump when doing
Fixed optimization bug in
SELECT ... LEFT JOIN ...
key_col IS NULL
key_col could contain
Fixed problem with 8-bit characters as separators in