MySQL 3.22.29 and 3.23.8 for Unix released

[Michael Widenius]

Hi!

MySQL 3.22.29 and 3.23.8 are now released for Unix;  They should be on
our mirror site after a short while, so please don't mail us if you
try to get it right away!

The 3.23 series seems to stabilize quite good.  If you don't have any
of the problems listed in the Changelog, you don't have to upgrade
from 3.23.7.

We hope this is the last 3.22 release; This mainly fixes some small
problems in the 3.22.27 and 3.22.28.  The biggest 'known bug' this
release fixes is that in some not very likely cases,
when using packed text keys, the index could get corrupted on delete.

Note:  This release doesn't fix any Y2K bugs, as we haven't found any :)


Changes in release 3.23.8
-------------------------

   * Fixed problem when handling bigger indexfiles than 8G.

   * Added latest patches to mit-pthreads for NetBSD.

   * Fixed problem with timezones that are < GMT -11.

   * Fixed a bug when deleting packed keys in `NISAM'.

   * Fixed problem with `ISAM' when doing some `ORDER BY .. DESC'
     queries.

   * Fixed bug when doing a join on a text key which didn't cover the
     whole key.

   * Option `--delay-key-write' didn't enable delayed key writing.

   * Fixed update of `TEXT' column which only involved case changes.

   * Fixed that `INSERT DELAYED' doesn't update timestamps that are
     given.

   * Added function `YEARWEEK()' and options `x', `X', `v' and `V' to
     `DATE_FORMAT()'.

   * Fixed problem with `MAX(indexed_column)' and HEAP tables.

   * Fixed problem with `BLOB NULL' keys and `LIKE' "prefix%".

   * Fixed problem with `MyISAM' and fixed length rows < 5 bytes.

   * Fixed problem that could cause *MySQL* to touch freed memory when
     doing very complicated `GROUP BY' queries.

   * Fixed core dump if you got a crashed table where an `ENUM' field
     value was too big.


Changes in release 3.22.29
--------------------------

   * Upgraded the configure and include files to match the latest 3.23
     version.  This should increase portability and make it easier to
     build shared libraries.

   * Added latest patches to mit-pthreads for NetBSD.

   * Fixed problem with timezones that are < GMT -11.

   * Fixed a bug when deleting packed keys in NISAM.

   * Fixed problem that could cause *MySQL* to touch freed memory when
     doing very complicated `GROUP BY' queries.

   * Fixed core dump if you got a crashed table where an `ENUM' field
     value was too big.

   * Added `mysqlshutdown.exe' and `mysqlwatch.exe' to the Windows
     distribution.

   * Fixed problem when doing `ORDER BY' on a reference key.

   * Fixed that `INSERT DELAYED' doesn't update timestamps that are
     given.


Regards,
Monty

PS: Happy new year to you all.   The best thing with this new year
    that the many mails we got about 'Is MySQL REALLY Y2K safe, should
    decrease rapidly' :)