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.
          
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.

