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 bug in
REPLACE ... SELECT ... which could give a corrupted table.
Fixed bug in myisamchk where it incorrectly reset the
LOTS of patches for Linux Alpha. MySQL now appears to be relatively stable on Alpha.
HEAP temporary tables to use hashed keys to quickly find duplicated rows. This mostly concerns queries of type
SELECT DISTINCT ... GROUP BY .... This fixes a problem where not all duplicates were removed in queries of the above type. In addition, the new code is MUCH faster.
Added patches to make MySQL compile on Mac OS X.
IF NOT EXISTS clause to
--databases options to mysqldump to allow dumping of many databases at the same time.
Fixed bug in compressed
DECIMAL() index in
Fixed bug when storing 0 into a timestamp.
When doing mysqladmin shutdown on a local connection, mysqladmin now waits until the PID file is gone before terminating.
Fixed core dump with some
COUNT(DISTINCT ...) queries.
Fixed that myisamchk works properly with RAID tables.
Fixed problem with
LEFT JOIN and
key_col IS NULL
Fixed bug in
net_clear() which could give the error
Aborted connection in the MySQL clients.
USE INDEX ( and
IGNORE INDEX ( as parameters in
RENAME should now work on