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 in
FIND_IN_SET() when the first argument was
Added table locks to Berkeley DB.
Fixed a bug with
LEFT JOIN and
ORDER BY where the first table had only one matching row.
Added 4 sample
my.cnf example files in the
duplicated key problem when doing big
GROUP BY operations. (This bug was probably introduced in 3.23.15.)
Changed syntax for
INNER JOIN to match standard SQL.
NATURAL JOIN syntax.
A lot of fixes in the
Added handling of
--defaults-file to safe_mysqld.sh and mysql_install_db.sh.
Fixed bug in reading compressed tables with many threads.
USE INDEX works with
BEGIN statement to start a transaction in
Added support for symbolic links for Windows.
Changed protocol to let client know if the server is in
autocommit mode and if there is a pending transaction. If there is a pending transaction, the client library gives an error before reconnecting to the server to let the client know that the server did a rollback. The protocol is still backward-compatible with old clients.
KILL now works on a thread that is locked on a 'write' to a dead client.
Fixed memory leak in the replication slave thread.
log-slave-updates option to mysqld, to allow daisy-chaining the slaves.
Fixed compile error on FreeBSD and other systems where
pthread_t is not the same as
Fixed master shutdown aborting the slave thread.
Fixed a race condition in
INSERT DELAYED code when doing
Added deadlock detection sanity checks to