Fonctionnalité ajoutée ou modifiée :
Added --with-big-tables
compilation option
to configure. (Previously it was
necessary to pass -DBIG_TABLES
to the
compiler manually in order to enable large table support.)
Section 2.4.2, « Options habituelles de configure
» for details.
Bogues corrigés :
Fixed a deadlock resulting from use of FLUSH TABLES
WITH READ LOCK
while an INSERT
DELAYED
statement is in progress. (Bug#7823)
Fixed a segmentation fault in mysqlcheck
that occurred when the last table checked in
--auto-repair
mode returned an error (such
as the table being a MERGE
table). (Bug#9492)
Fixed faulty display of TIMESTAMP
columns
retrieved as
while the col_name
+0new
system variable is set to
1. (Bug#8894)
Queries containing CURRENT_USER()
incorrectly were registered in the query cache. (Bug#9796)
Fixed problems with static variables to allow building on Fedora Core 3. (Bug#6554)
An UPDATE
that updated only some of the
columns in a multiple-column index could result in a loop.
(Bug#8942)
REPAIR TABLE
did not invalidate query
results in the query cache that were generated from the
table. (Bug#8480)
Fixed a bug that caused concurrent inserts to be allowed
into the tables in the SELECT ... UNION
...
part of INSERT ... SELECT ... UNION
...
. This could result in the incorrect order of
queries in the binary log. (Bug#9922)
Fixed a bug that under certain circumstances could allow a
privilege escalation via database wildcards in
GRANT
. (Bug#3924, CVE-2004-0957)
<=>
was not properly comparing
NULL
values in the
WHERE
clause of outer joins. (Bug#8711)
InnoDB: Fixed a bug : MySQL-4.0.23 and 4.0.24 could complain that an InnoDB table created with MySQL-3.23.49 or earlier was in the new compact InnoDB table format of 5.0.3 or later, and InnoDB would refuse to use that table. (The same bug exists in 4.1.8 - 4.1.10.) There is nothing wrong with the table, it is mysqld that is in error. Workaround: wait that 4.0.25 or 4.1.11 is released before doing an upgrade, or dump the table and recreate it with any MySQL version >= 3.23.50 before upgrading to 4.0.23 or 4.0.24.
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.