Functionality added or changed:
Added syntax support for
options (to be able to read table dumps from 4.1).
Fixed replication bug that caused the slave to loose its position in some cases when the replication log was rotated.
Fixed that a slave will restart from the start of a transaction if it's killed in the middle of one.
Moved the manual pages from
man/man1 in the binary distributions.
The default type returned by
is now set to be the more 'general' of the types of
B. (The order is
mysql.server startup script in
the RPM packages from
/etc/init.d/mysql (which almost all
current Linux distributions support for LSB compliance).
variable (number of queries that were deleted from cache
because of low memory).
mysqlcheck so it can deal with
table names containing dashes.
Bulk insert optimization (see
SHOW VARIABLES」) is no longer used when
inserting small (less than 100) number of rows.
Optimization added for queries like
SELECT ... FROM
merge_table WHERE indexed_column=constant_expr.
LOCALTIMESTAMP as synonyms for
CEIL is now an alias for
CURRENT_USER() function can be used
to get a
user@host value as it was
matched in the
GRANT system. See
CHECK constraints to be compatible
with SQL-99. This made
CHECK a reserved
word. (Checking of
CHECK constraints is
still not implemented).
CAST(... as CHAR).
Added PostgreSQL compatible
SELECT ... LIMIT row_count OFFSET offset
mysql_change_user() will now reset the
connection to the state of a fresh connect (Ie,
ROLLBACK any active transaction, close
all temporary tables, reset all user variables etc..)
CHANGE MASTER and
SLAVE now require that slave threads be both
already stopped; these commands will return an error if at
least one of these two threads is running.
Fixed number of found rows returned in
--lower-case-table-names default on
Mac OS X as the default file system (HFS+) is case
insensitive. See 項6.1.3. 「名前におけるケース依存」.
AUTOCOMMIT=0 mode didn't
rotate binary log.
A fix for the bug in a
SELECT with joined
ORDER BY and
LIMIT clause when filesort had to be
used. In that case
LIMIT was applied to
filesort of one of the tables, although it could not be.
This fix also solved problems with
mysql_server_init() now makes a copy of
all arguments. This fixes a problem when using the embedded
server in C# program.
Fixed buffer overrun in
library that allowed a malicious
server to crash the client application.
Fixed security-related bug in
mysql_change_user() handling. All users
are strongly recommended to upgrade to version 4.0.6.
Fixed bug that prevented
command-line option of
Fixed bug in phrase operator
boolean full-text search.
Fixed bug that caused
OPTIMIZE TABLE to
corrupt the table under some rare circumstances.
Part rewrite of multiple-table-update to optimize it, make it safer and more bug free.
LOCK TABLES now works together with
multiple-table-update and multiple-table-delete.
--replicate-do=xxx didn't work for
UPDATE commands. (Bug introduced in
Fixed shutdown problem on Mac OS X.
InnoDB bugs in
AUTO_INCREMENT, INSERT INTO ... SELECT ... were
fixed. See the
InnoDB changelog in the
InnoDB section of the manual.
RESET SLAVE caused a crash if the slave
threads were running.
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.