MySQL

3.23.17

Released on 7 Jun 2000
MySQL 3.23.17 Changelog

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 NULL.

  • 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 support-files directory.

  • Fixed 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.

  • Added NATURAL JOIN syntax.

  • A lot of fixes in the BDB interface.

  • Added handling of --no-defaults and --defaults-file to safe_mysqld.sh and mysql_install_db.sh.

  • Fixed bug in reading compressed tables with many threads.

  • Fixed that USE INDEX works with PRIMARY keys.

  • Added BEGIN statement to start a transaction in autocommit mode.

  • 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.

  • Added new 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 int.

  • Fixed master shutdown aborting the slave thread.

  • Fixed a race condition in INSERT DELAYED code when doing ALTER TABLE.

  • Added deadlock detection sanity checks to INSERT DELAYED.