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.
