Fixed bug in MyISAM
involving
REPLACE ... SELECT ...
which could give a
corrupted table.
Fixed bug in myisamchk
where it
incorrectly reset the AUTO_INCREMENT
value.
LOTS of patches for Linux Alpha. MySQL now appears to be relatively stable on Alpha.
Changed DISTINCT
on
HEAP
temporary tables to use hashed keys
to quickly find duplicated rows. This mostly concerns
queries of type SELECT DISTINCT ... GROUP BY
...
. This fixes a problem where not all duplicates
were removed in queries of the above type. In addition, the
new code is MUCH faster.
Added patches to make MySQL compile on Mac OS X.
Added IF NOT EXISTS
clause to
CREATE DATABASE
.
Added --all-databases
and
--databases
options to
mysqldump
to allow dumping of many
databases at the same time.
Fixed bug in compressed DECIMAL()
index
in MyISAM
tables.
Fixed bug when storing 0 into a timestamp.
When doing mysqladmin shutdown
on a local
connection, mysqladmin
now waits until
the PID file is gone before terminating.
Fixed core dump with some COUNT(DISTINCT
...)
queries.
Fixed that myisamchk
works properly with
RAID tables.
Fixed problem with LEFT JOIN
and
key_field IS NULL
.
Fixed bug in net_clear()
which could give
the error Aborted connection
in the MySQL
clients.
Added options USE INDEX (key_list)
and
IGNORE INDEX (key_list)
as parameters in
SELECT
.
DELETE
and RENAME
should now work on RAID
tables.
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.