Skip navigation links
MySQL 3.23, 4.0, 4.1 Reference Manual :: B MySQL Change History :: B.3 Changes in Release 3.23.x :: B.3.56 Changes in Release 3.23.5 (20 October 1999)
B.3.57 Changes in Release 3.23.4 (28 September 1999) »
Section Navigation      [Toggle]

B.3.56. Changes in Release 3.23.5 (20 October 1999)

End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.

  • 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.

  • Adding a column after the last field with ALTER TABLE didn't work.

  • Fixed problem when using an AUTO_INCREMENT column in two keys

  • With MyISAM, you now can have an AUTO_INCREMENT column as a key 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 field name with CREATE TABLE tbl_name SELECT ... didn't work.

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

  • Do not 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 for the last inserted row with WHERE auto_increment_column IS NULL.

  • Added new variable concurrency to mysqld for Solaris.

  • Added --relative option 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 user-defined functions.