End of Product Lifecycle. Active 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 a bug when
MERGE table sometimes results in incorrectly ordered rows.
Fixed a bug in
REPLACE() when using the
ujis character set.
BDB patches 126.96.36.199 and 188.8.131.52.
--skip-stack-trace option to mysqld.
CREATE TEMPORARY now works with
InnoDB now promotes sub keys to whole keys.
Better error message when slave
max_allowed_packet is too low to read a very long log event from the master.
Fixed bug when too many rows were removed when using
SELECT DISTINCT ... HAVING.
SHOW CREATE TABLE now returns
TEMPORARY for temporary tables.
Rows_examined to slow query log.
Fixed problems with function returning empty string when used together with a group function and a
WHERE that didn't match any rows.
New program mysqlcheck.
Added database name to output for administrative commands like
Lots of portability fixes for
Changed optimizer so that queries like
SELECT * FROM use an index on
tbl_name2 ... ORDER BY
key_part1 instead of
Fixed bug when doing
LOCK TABLE when
to_table WRITE,...; INSERT INTO
to_table... SELECT ...
to_table was empty.
Fixed bug with
LOCK TABLE and