Functionality added or changed:
ENGINE
is now a synonym for the
TYPE
option for CREATE
TABLE
and ALTER TABLE
.
Added init_connect
and
init_slave
server variables. The values
should be SQL statements to be executed when each client
connects or each time a slave's SQL thread starts,
respectively.
C API enhancement:
SERVER_QUERY_NO_INDEX_USED
and
SERVER_QUERY_NO_GOOD_INDEX_USED
flags are
now set in server_status
field of
MYSQL
structure. It is these flags that
make the query to be logged as slow if
mysqld
was started with
--log-slow-queries
--log-queries-not-using-indexes
.
Bugs fixed:
Fixed a bug with the INTERVAL()
function
when 8 or more comparison arguments are provided. (Bug#1561)
Packaging: Fixed a bug in the Mac OS PKG
postinstall
script
(mysql_install_db
was called with an
obsolete argument).
Packaging: Added missing file
mysql_create_system_tables
to the
server RPM package. This bug was fixed for the 4.1.1 RPMs by
updating the MySQL-server RPM from
MySQL-server-4.1.1-0
to
MySQL-server-4.1.1-1
. The other RPMs were
not affected by this change.
Fixed a bug in myisamchk
and
CHECK TABLE
that sometimes resulted in a
spurious error Found key at page ..... that points
to record outside datafile
for a table with a
FULLTEXT
index. (Bug#1977)
Fixed a hang in full-text indexing of strings in multi-byte
(all besides utf8
) charsets. (Bug#2065)
Fixed a crash in full-text indexing of UTF-8 data. (Bug#2033)
Replication: a rare race condition in the slave SQL thread that could lead to an incorrect complaint that the relay log is corrupted. (Bug#2011)
Replication: if an administrative command on a table
(OPTIMIZE TABLE
, REPAIR
TABLE
etc) was run on the slave, this could
sometimes stop the slave SQL thread (this did not lead to
any corruption; one just had to type START
SLAVE
to get replication going again). (Bug#1858)
Replication: in the slave SQL thread, a multi-table
UPDATE
could produce an incorrect
complaint that some record was not found in one table, if
the UPDATE
was preceded by a
INSERT ... SELECT
. (Bug#1701)
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.