Skip navigation links
B.3.23 Changes in Release 3.23.37 (17 April 2001) »
Section Navigation      [Toggle]

B.3.22. Changes in Release 3.23.38 (09 May 2001)

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 SELECT from MERGE table sometimes results in incorrectly ordered rows.

  • Fixed a bug in REPLACE() when using the ujis character set.

  • Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2.

  • Added --skip-stack-trace option to mysqld.

  • CREATE TEMPORARY now works with InnoDB tables.

  • InnoDB now promotes sub keys to whole keys.

  • Added option CONCURRENT to LOAD DATA.

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

  • Added 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 CHECK TABLE, REPAIR TABLE, OPTIMIZE TABLE.

  • Lots of portability fixes for InnoDB.

  • Changed optimizer so that queries like SELECT * FROM tbl_name, tbl_name2 ... ORDER BY key_part1 LIMIT row_count use an index on key_part1 instead of filesort.

  • Fixed bug when doing LOCK TABLE to_table WRITE,...; INSERT INTO to_table... SELECT ... when to_table was empty.

  • Fixed bug with LOCK TABLE and BDB tables.