Fonctionnalité ajoutée ou modifiée :
InnoDB: Made LOCK TABLES
behave by
default like it did before MySQL 4.0.20 or 4.1.2: no
InnoDB
lock will be taken. Added a
startup option and settable system variable
innodb_table_locks
for making
LOCK TABLE
acquire also
InnoDB
locks. See
Section 15.17, « Restrictions sur les tables InnoDB
». (Bug#3299, Bug#5998)
Bogues corrigés :
Fixed a bug with FOUND_ROWS()
used
together with LIMIT
clause in prepared
statements. (Bug#6088)
Fixed a bug with NATURAL JOIN
in prepared
statements. (Bug#6046).
Fixed a bug in join of tables from different databases having columns with identical names (prepared statements). (Bug#6050)
Now implicit access to system time zone description tables
(which happens when you set time_zone
variable or use CONVERT_TZ()
function)
does not require any privileges. (Bug#6116)
Fixed a bug which caused server crash when deprecated
libmysqlclient
functilon
mysql_create_db()
was called. (Bug#6081)
Fixed REVOKE ALL PRIVILEGES, GRANT OPTION FROM
so that all
privileges are revoked correctly. (Bug#5831). This corrects
a case that the fix in 4.1.6 could miss.
user
Fixed a bug that could cause MyISAM index corruption when
key values start with character codes below
BLANK
. This was caused by the new key
sort order in 4.1. (Bug#6151)
Fixed a bug in the prepared statements protocol when wrong
metadata was sent for SELECT
statements
not returning a result set (such as SELECT ... INTO
OUTFILE
). (Bug#6059)
Fixed bug which allowed to circumvent missing UPDATE privilege if one had INSERT and SELECT privileges for table with primary key. (Bug#6173)
Fixed a bug in libmysqlclient
with wrong
conversion of negative time values to strings. (Bug#6049).
Fixed a bug in libmysqlclient
with wrong
conversion of zero date values
(0000-00-00
) to strings. (Bug#6058)
Fixed a bug that caused the server to crash on attempt to
prepare a statement with RAND(?)
. (Bug#5985)
Fixed a bug with handling of DATE
,
TIME
, and DATETIME
columns in the binary protocol. The problem is
compiler-specific and could have been observed on HP-UX,
AIX, Solaris9, when compiling with native compiler. (Bug#6025)
Fixed a bug with handling of TINYINT
columns in the binary protocol. The problem is specific to
platforms where the C compiler has the
char
data type unsigned by default. (Bug#6024)
Fixed problem introduced in MySQL 4.0.21 where a connection
starting a transaction, doing updates, then FLUSH
TABLES WITH READ LOCK
, then
COMMIT
, would cause replication slaves to
stop complaing about error 1223. Bug surfaced when using the
InnoDB innobackup
script. (Bug#5949)
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.