Released on 18 Jul 2001
MySQL 3.23.40 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 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 problem with --low-priority-updates and INSERT statements.

  • Fixed bug in slave thread when under some rare circumstances it could get 22 bytes ahead on the offset in the master.

  • Added slave_net_timeout for replication.

  • Fixed problem with UPDATE and BDB tables.

  • Fixed hard bug in BDB tables when using key parts.

  • Fixed problem when using GRANT FILE ON database.* ...; previously we added the DROP privilege for the database.

  • Fixed DELETE FROM tbl_name ... LIMIT 0 and UPDATE FROM tbl_name ... LIMIT 0, which acted as though the LIMIT clause was not present (they deleted or updated all selected rows).

  • CHECK TABLE now checks whether an AUTO_INCREMENT column contains the value 0.

  • Sending a SIGHUP to mysqld now only flushes the logs, but does not reset the replication.

  • Fixed parser to allow floats of type 1.0e1 (no sign after e).

  • Option --force to myisamchk now also updates states.

  • Added option --warnings to mysqld. Now mysqld prints the error Aborted connection only if this option is used.

  • Fixed problem with SHOW CREATE TABLE when you didn't have a PRIMARY KEY.

  • Properly fixed the rename of innodb_unix_file_flush_method variable to innodb_flush_method.

  • Fixed bug when converting BIGINT UNSIGNED to DOUBLE. This caused a problem when doing comparisons with BIGINT values outside of the signed range.

  • Fixed bug in BDB tables when querying empty tables.

  • Fixed a bug when using COUNT(DISTINCT) with LEFT JOIN and there weren't any matching rows.

  • Removed all documentation referring to the GEMINI table type. GEMINI is not released under an Open Source license.