Fixed that databasename works as second
argument to mysqlhotcopy.
The values for the UMASK and
UMASK_DIR environment variables now can
be specified in octal by beginning the value with a zero.
Added RIGHT JOIN. This makes
RIGHT a reserved word.
Added @@IDENTITY as a synonym for
LAST_INSERT_ID(). (This is for MSSQL
compatibility.)
Fixed a bug in myisamchk and
REPAIR when using
FULLTEXT index.
LOAD DATA INFILE now works with FIFOs.
(Patch by Toni L. Harbaugh-Blackford.)
FLUSH LOGS broke replication if you
specified a log name with an explicit extension as the value
of the log-bin option.
Fixed a bug in MyISAM with packed
multi-part keys.
Fixed crash when using CHECK TABLE on
Windows.
Fixed a bug where FULLTEXT index always
used the koi8_ukr character set.
Fixed privilege checking for CHECK TABLE.
The MyISAM repair/reindex code didn't use
the --tmpdir option for its temporary
files.
Added BACKUP TABLE and RESTORE
TABLE.
Fixed core dump on CHANGE MASTER TO when
the slave did not have the master to start with.
Fixed incorrect Time in the processlist
for Connect of the slave thread.
The slave now logs when it connects to the master.
Fixed a core dump bug when doing FLUSH
MASTER if you didn't specify a filename argument
to --log-bin.
Added missing ha_berkeley.x files to
the MySQL Windows distribution.
Fixed some mutex bugs in the log code that could cause thread blocks if new log files couldn't be created.
Added lock time and number of selected processed rows to slow query log.
Added --memlock option to
mysqld to lock mysqld
in memory on systems with the mlockall()
call (as in Solaris).
HEAP tables didn't use keys properly.
(Bug from 3.23.23.)
Added better support for MERGE tables
(keys, mapping, creation, documentation...). See
Section 14.2, « Tables assemblées MERGE ».
Fixed bug in mysqldump from 3.23 which
caused some CHAR columns not to be
quoted.
Merged analyze, check,
optimize and repair code.
OPTIMIZE TABLE is now mapped to
REPAIR with statistics and sorting of the
index tree. This means that for the moment it only works on
MyISAM tables.
Added a pre-alloced block to root_malloc to get fewer mallocs.
Added a lot of new statistics variables.
Fixed ORDER BY bug with
BDB tables.
Removed warning that mysqld couldn't
remove the .pid file under Windows.
Changed --log-isam to log
MyISAM tables instead of isam tables.
Fixed CHECK TABLE to work on Windows.
Added file mutexes to make pwrite() safe
on Windows.
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.
