D.4.55 Changes in release 3.23.5 (20 Oct 1999)

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

User Comments

Add your own comment.