Bugs fixed for MySQL-4.0.16

The following issues have been resolved in 4.0.16.

* Fixed crash of Query Cache on queries which use same table several times.

* Fixed core dump bug when setting an enum system variable (like `SQL_WARNINGS') to `NULL'.

* Fixed server crash when running `FLUSH QUERY CACHE'. (Bug #988)

* Extended default timeout in clients on windows from 30 seconds to 1 year. (The timeout that was added in MySQL 4.0.15 was way too short).

* More "out of memory" checking in range optimiser.

* Fixed and documented problem when setting and using a user variable in the same `SELECT' statement. (Bug #1194).

* Fixed bug in overrun check for blobs with compressed tables (bug introduced in 4.0.14). This caused MySQL to regard some correct tables with blobs to be corrupted. (Bug #770, Bug #1304, and maybe Bug #1295)

* `SHOW GRANTS' showed `USAGE' instead of real privileges for column grants when no table grants was given.

* When it wanted to copy a database from the master, `LOAD DATA FROM MASTER' dropped the corresponding database on the slave, thus dropping tables which may not have a counterpart on the master, or tables which may be excluded from replication using `replicate-*-table' rules. Now `LOAD DATA FROM MASTER' does not drop the database anymore, it drops only the tables which have a counterpart on the master and which match the `replicate-*-table' rules. `replicate-*-db' rules can still be used to include/exclude a database as a whole from `LOAD DATA FROM MASTER'. A database will also be included/excluded as a whole if there are some rules like `replicate-wild-do-table=db1.%' or `replicate-wild-ignore-table=db1.%', like it's already the case for `CREATE DATABASE' and `DROP DATABASE' in replication. (Bug #1248)

* `mysqlbinlog' crashed (segmentation fault) when used with the `-h, --host' option. (Bug #1258)

* `mysqlbinlog' crashed (segmentation fault) when used on binlog containing only final events for `LOAD DATA'. (Bug #1340)

* Fixed compilation problem when compiling with OpenSSL 0.9.7 with disabled old DES support (If `OPENSSL_DISABLE_OLD_DES_SUPPORT' option was enabled).

* Slave no longer can delete temporary files for `LOAD DATA' (`SQL_LOAD-*') belonging to other instances if these instances use the same temporary directory. (Bug #1357)

* If `LOAD DATA INFILE' failed for a small file, the master forgot to write a marker (a `Delete_file' event) in its binary log, so the slave could not delete 2 files (`SQL_LOAD*.info' and `SQL_LOAD*.data' from its `tmpdir'. (Bug #1391)

* On Windows, the slave forgot to delete a `SQL_LOAD*.info' file from `tmpdir' after successfully replicating a `LOAD DATA INFILE' command. (Bug #1392)

* When a connection terminates, MySQL writes `DROP TEMPORARY TABLE' statements to the binary log for all temporary tables which the connection had not explicitely dropped. MySQL forgot to backquote the database and table names in the statement. (Bug #1345)

* On some 64-bit machines (some HP-UX and Solaris machines), a slave installed with the 64-bit MySQL binary could not connect to its master (it connected to itself instead). (Bug #1256, #1381)

* Code introduced in MySQL 4.0.15 for the slave to detect that the master had died while writing a transaction to its binlog, reported an error in a legal situation (when the slave I/O thread was stopped while copying a transaction to the relay log, the slave SQL thread would later pretend that it found an unfinished transaction). (Bug #1475)

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