Software Update: MySQL 3.23.42

Xoror announced that a new version of MySQL has been released. Given the large number of bug fixes, this version is definitely worth upgrading. The Windows binaries have not been released yet, but the source code and binaries for almost all other supported platforms can already be downloaded from the MySQL download page† Below is the changelog of release 3.23.42:

• Fixed problem with REPAIR TABLE on MyISAM tables with row lengths between 65517 – 65520 bytes
• Fixed rare hang when doing mysqladmin shutdown when there was a lot of activity in other threads.
• Fixed problem with INSERT DELAYED where delay thread could be hanging on upgrading locks without any apparent reasons.
• Fixed problem with myisampack and BLOB.
• Fixes problem when one edited .MRG tables by hand. (Patch from Benjamin Pflugmann).
• Enforce that all tables in a MERGE table come from the same database.
• Fixed bug with LOAD DATA INFILE and transactional tables.
• Fix bug when using INSERT DELAYED with wrong column definition.
• Fixed coredump during REPAIR of some particularly broken tables.
• Fixed bug in InnoDB and AUTO_INCREMENT columns.
• Fixed bug in InnoDB and RENAME TABLE columns.
• Fixed critical bug in InnoDB and BLOB columns. If one has used BLOB columns larger than 8000 bytes in an InnoDB table, one must dump the table with mysqldump, drop it and restore it from the dump.
• Applied large patch for OS/2 from Yuri Dario.
• Fixed problem with InnoDB when one could get the error Can’t execute the given command… even when one didn’t have an active transaction.
• Applied some minor fixes that concern Gemini.
• Use real arithmetic operations even in integer context if not all arguments are integers. (Fixes uncommon bug in some integer contexts).
• Don’t force everything to lower cases on Windows. (To fix problem with Windows and ALTER TABLE). Now –lower_case_names also works on Unix.
• Fixed that automatic rollback that is done when thread end doesn’t lock other threads.