Hi! MySQL 3.23.42 is now released. We recommend anyone using BDB tables or InnoDB tables with BLOB's to upgrade to this new release. If you are using InnoDB tables with BLOBS bigger than 8000 bytes, you should do a mysqldump of the table and then drop and recreate the table. Most other bug fixes are for unlikely or minor bugs. As always, don't be concerned if you can't find this release on web site or on our mirrors right away; It takes some time for the web site to be updated from our development site. Changes in release 3.23.42 -------------------------- * Fixed problem when using `LOCK TABLES' and `BDB' tables. * 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 context). * 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. Regards, Monty --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php