MySQL 4.0.22 has been released

Hi,

MySQL 4.0.22, a new version of the popular Open Source/Free Software
Database Management System has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://dev.mysql.com/downloads/ and mirror sites.

Note that not all mirror sites may be up-to-date at this point. If you
cannot find this version on a particular mirror, please try again later or
choose another download site.

This is a bug fix release for the previous production version.

Please refer to our bugs database at http://bugs.mysql.com/ for more details
about the individual bugs fixed in this version.

Changes in release 4.0.22:

   Functionality added or changed:
     * The --with-openssl option for configure now accepts a path prefix
       as an argument. --with-openssl-includes and --with-openssl-libs
       are still supported, but are needed only to override the default
       values. (Bug #5494)
     * Added new --without-man option to configure to suppress
       building/installing the manual pages. (Bug #5379)
     * InnoDB: New mysqld option --innodb-table-locks and session
       variable innodb_table_locks (on by default). You can now disable
       InnoDB table locks if your application depends on the way MySQL
       did table locks before 4.0.20. See section "Restrictions on InnoDB
       Tables" in the manual. (Bug #3299, Bug #5998)

   Bugs fixed:
     * Fixed bug in server which caused connection stall when one of
       deprecated libmysqlclient functions mysql_create_db(),
       mysql_rm_db() were called and were going to return error. (Bug
       #6081)
     * Fixed returning wrong query result from query cache if a temporary
       table was hiding a real table after putting results to query cache.
       (Bug #6084)
     * Fixed ENABLE KEYS, which failed if tmpdir ran out of space. Now, a
       full repair is done in this case. (Bug #5625)
     * Fixed an improper error message when trying to drop a table which
       is referenced by a FOREIGN KEY constraint. (Bug #5784)
     * Fixed a bug that allowed FLUSH TABLE(S) to close HANDLER tables.
       HANDLER tables are now reopened after a FLUSH TABLE(S) the next time
       they are used. However, they lose their file position if this
       happens. (Bug #4286)
     * Fixed a bug that allowed HANDLER tables with the same alias to be
       opened multiple times. HANDLER aliases must now be unique, even
       though it is syntactically correct in versions below 4.1, to qualify
       them with their base table's database name (e.g. test_db.handler_tbl,
       but this will now conflict with e.g. another_db.handler_tbl). (Bug
       #4335)
     * Fixed crash when using MySQL 4.0 with privilege tables from MySQL
       5.0.
     * InnoDB: Make the check for excessive semaphore waits tolerate
       glitches in the system clock (do not crash the server if the
       system time is adjusted while InnoDB is under load.). (Bug #5898)
     * mysqlimport now reads input files locally from the client host
       only if the --local option is given. Previously, it assumed
       incorrectly in some cases that files were local even without
       --local. (Bug #5829)
     * InnoDB: Fixed a bug in the InnoDB FOREIGN KEY parser that
       prevented ALTER TABLE of tables containing `#' in their names.
       (Bug #5856)
     * InnoDB: Fixed problem introduced in 4.0.21 where a connection
       starting a transaction, doing updates, then FLUSH TABLES WITH READ
       LOCK, then COMMIT, would cause replication slaves to stop
       complaining about error 1223. Bug surfaced when using the InnoDB
       innobackup script. (Bug #5949)
     * InnoDB: If one updated a column so that its size changed, or
       updated it to an externally stored (TEXT or BLOB) value, then
       ANOTHER externally stored column would show up as 512 bytes of
       good data + 20 bytes of garbage in a consistent read that fetched
       the old version of the row. (Bug #5960)
     * InnoDB: Release the dictionary latch during a long cascaded
       FOREIGN KEY operation, so that we do not starve other users doing
       CREATE TABLE or other DDL operations. This caused a notorious 'Long
       semaphore wait' message to be printed to the `.err' log. (Bug
       #5961)
     * Fixed a bug which resulted in an erroneously calculated number of
       examined rows in UNIONs. This value is printed in the slow query
       log. (Bug #5879)
     * Fixed bug with crash of server on some values of
       read_rnd_buffer_size (Bug #5492)
     * Fixed bug which caused truncation of values read from or into
       TIMESTAMP fields if --new mode was enabled. (Bug #4131)
     * mysqladmin now returns a status of 0 even when the server denies
       access; such an error means the server is running. (Bug #3120)
     * InnoDB: Fixed a bug introduced in 4.0.21. An assertion failed if
       one used mysqldump with the option -l or --opt, or if one used
       LOCK TABLES ... LOCAL. (Workaround in 4.0.21: use --quick and
       --single-transaction. (Bug #5538)
     * Fixed that if the slave SQL thread found a syntax error in a query
       (which should be rare, as the master parsed it successfully), it
       stops. (Bug #5711)
     * Fixed that if a write to a MyISAM table fails because of a full
       disk or an exceeded disk quota, it prints a message to the error
       log every 10 minutes, and waits until disk becomes free. (Bug
       #3248)
     * Fixed problem with symlinked databases on Windows being shown with
       SHOW DATABASES even if the database name doesn't match the given
       wildcard (Bug #5539)

Additional Notes:

     * Due to a temporary hardware failure the binaries for HP-UX 11.11
       are missing from the initial release. They will be provided as soon
       as this HP-UX build system is online again.

Enjoy!

   Matt

-- 
Matt Wagner, Production Engineer
MySQL AB, www.mysql.com
Northfield, MN, USA



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=gcdmg-mysql@xxxxxxxxxxx