MySQL Manual | D.4.48 Changes in release 3.23.12 (07 Mar 2000)

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.

User Comments