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.