MySQL 4.0.18 released

February 13, 2004

The latest production version of MySQL was released on February 12. This release includes added and changed functionality and bug fixes.

Functionality added or changed:

Fixed processing of LOAD DATA by mysqlbinlog in remote mode. (Bug #1378)
New utility program `myisam_ftdump’ was added to binary distributions.
mysqlhotcopy now works on NetWare.
ENGINE is now a synonym for the TYPE option for CREATE TABLE and ALTER TABLE.
lower_case_table_names system variable now can take a value of 2, to store table names in mixed case on case-insensitive filesystems.
For replication of HEAP tables: Made the master automatically write a DELETE FROM statement to its binary log when a HEAP table is opened for the first time since master’s startup. This is for the case where the slave has replicated a non-empty HEAP table, then the master is shut down and restarted: the table is now empty on master; the DELETE FROM empties it on slave too. Note that even with this fix, between the master’s restart and the first use of the table on master, the slave still has out-of-date data in the table. But if you use the init-file option to populate the HEAP table on the master at startup, it ensures that the failing time interval is zero. (Bug #2477)