MySQL

3.23.34

Released on 10 Mar 2001
MySQL 3.23.34 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.

  • Added the INNOBASE storage engine and the BDB storage engine to the MySQL source distribution.

  • Updated the documentation about GEMINI tables.

  • Fixed a bug in INSERT DELAYED that caused threads to hang when inserting NULL into an AUTO_INCREMENT column.

  • Fixed a bug in CHECK TABLE / REPAIR TABLE that could cause a thread to hang.

  • Fixed problem that REPLACE would not replace a row that conflicts with an AUTO_INCREMENT generated key.

  • mysqld now only sets CLIENT_TRANSACTIONS in mysql->server_capabilities if the server supports a transaction-safe storage engine.

  • Fixed LOAD DATA INFILE to allow numeric values to be read into ENUM and SET columns.

  • Improved error diagnostic for slave thread exit.

  • Fixed bug in ALTER TABLE ... ORDER BY.

  • Added max_user_connections variable to mysqld.

  • Limit query length for replication by max_allowed_packet, not the arbitrary limit of 4MB.

  • Permit space around = in argument to --set-variable.

  • Fixed problem in automatic repair that could leave some threads in state Waiting for table.

  • SHOW CREATE TABLE now displays the UNION=() for MERGE tables.

  • ALTER TABLE now remembers the old UNION=() definition.

  • Fixed bug when replicating timestamps.

  • Fixed bug in bidirectional replication.

  • Fixed bug in the BDB storage engine that occurred when using an index on multiple-part key where a key part may be NULL.

  • Fixed MAX() optimization on sub-key for BDB tables.

  • Fixed problem where garbage results were returned when using BDB tables and BLOB or TEXT fields when joining many tables.

  • Fixed a problem with BDB tables and TEXT columns.

  • Fixed bug when using a BLOB key where a const row wasn't found.

  • Fixed that mysqlbinlog writes the timestamp value for each query. This ensures that one gets same values for date functions like NOW() when using mysqlbinlog to pipe the queries to another server.

  • Permit --skip-gemini, --skip-bdb, and --skip-innodb options to be specified when invoking mysqld, even if these storage engines are not compiled in to mysqld.

  • You can now use ASC and DESC with GROUP BY columns to specify a sort order.

  • Fixed a deadlock in the SET code, when one ran SET @foo=bar, where bar is a column reference, an error was not properly generated.