Renamed FLUSH MASTER
and FLUSH
SLAVE
to RESET MASTER
and
RESET SLAVE
.
Fixed <>
to work properly with
NULL
.
Fixed a problem with SUBSTRING_INDEX()
and REPLACE()
. (Patch by Alexander
Igonitchev)
Fix CREATE TEMPORARY TABLE IF NOT EXISTS
not to produce an error if the table exists.
If you don't create a PRIMARY KEY
in a
BDB
table, a hidden PRIMARY
KEY
will be created.
Added read-only-key optimization to BDB
tables.
LEFT JOIN
in some cases preferred a full
table scan when there was no WHERE
clause.
When using --log-slow-queries
, don't count
the time waiting for a lock.
Fixed bug in lock code on Windows which could cause the key cache to report that the key file was crashed even if it was okay.
Automatic repair of MyISAM
tables if you
start mysqld
with
--myisam-recover
.
Removed the TYPE=
keyword from
CHECK
and REPAIR
.
Allow CHECK
options to be combined. (You
can still use TYPE=
, but this usage is
deprecated.)
Fixed mutex bug in the binary replication log --- long update queries could be read only in part by the slave if it did it at the wrong time, which was not fatal, but resulted in a performance-degrading reconnect and a scary message in the error log.
Changed the format of the binary log --- added magic number, server version, binlog version. Added server ID and query error code for each query event.
Replication thread from the slave now will kill all the stale threads from the same server.
Long replication user names were not being handled properly.
Added --replicate-rewrite-db
option to
mysqld
.
Added --skip-slave-start
option to
mysqld
.
Updates that generated an error code (such as
INSERT INTO foo(some_key) values (1),(1)
)
erroneously terminated the slave thread.
Added optimization of queries where
DISTINCT
is only used on columns from
some of the tables.
Allow floating-point numbers where there is no sign after
the exponent (like 1e1
).
SHOW GRANTS
didn't always show all column
grants.
Added --default-extra-file=#
option to all
MySQL clients.
Columns referenced in INSERT
statements
now are initialised properly.
UPDATE
didn't always work when used with
a range on a timestamp that was part of the key that was
used to find rows.
Fixed a bug in FULLTEXT
index when
inserting a NULL
column.
Changed to use mkstemp()
instead of
tempnam()
. Based on a patch from John
Jones.
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.