GNU Info

(mysql.info)News-3.23.5

---

Next: News-3.23.4 Prev: News-3.23.6 Up: News-3.23.x

---

Enter node , (file) or (file)node

Changes in release 3.23.5
-------------------------

   * Fixed some Y2K problems in the new date handling in 3.23.

   * Fixed problem with `SELECT DISTINCT ... ORDER BY RAND()'.

   * Added patches by Sergei A. Golubchik for text searching on the
     MyISAM level.

   * Fixed cache overflow problem when using full joins without keys.

   * Fixed some configure issues.

   * Some small changes to make parsing faster.

   * `ALTER TABLE' + adding a column after the last field didn't work.

   * Fixed problem when using an auto_increment column in two keys

   * One can now with MyISAM have the auto_increment part as a sub part:
     `CREATE TABLE foo (a int not null auto_increment, b char(5),
     primary key (b,a))'

   * Fixed bug in MyISAM with packed char keys that could be `NULL'.

   * `AS' on fieldname with `CREATE TABLE table_name SELECT ...' didn't
     work.

   * Allow use of `NATIONAL' and `NCHAR' when defining character
     columns.  This is the same as not using `BINARY'.

   * Don't allow `NULL' columns in a `PRIMARY KEY' (only in `UNIQUE'
     keys).

   * Clear `LAST_INSERT_ID' if one uses this in ODBC: `WHERE
     auto_increment_column IS NULL'.  This seems to fix some problems
     with Access.

   * `SET SQL_AUTO_IS_NULL=0|1' now turns on/off the handling of
     searching after the last inserted row with `WHERE
     auto_increment_column IS NULL'.

   * Added new `mysqld' variable `concurrency' for Solaris.

   * Added option `--relative' to `mysqladmin' to make
     `extended-status' more useful to monitor changes.

   * Fixed bug when using `COUNT(DISTINCT ...)' on an empty table.

   * Added support for the Chinese character set GBK.

   * Fixed problem with `LOAD DATA INFILE' and `BLOB' columns.

   * Added bit operator `~' (negation).

   * Fixed problem with `UDF' functions.