Fonctionnalité ajoutée ou modifiée :
Added option --sigint-ignore to the
mysql command line client to make it
ignore SIGINT signals (typically the
result of the user pressing Control-C).
InnoDB: Added the startup option and settable global
variable innodb_max_purge_lag for
delaying INSERT,
UPDATE and DELETE
operations when the purge operations are lagging. The
default value of this parameter is zero, meaning that there
are no delays. See
Section 15.13, « Implémentation du multi-versionnage ».
InnoDB: The innodb_autoextend_increment
startup option that was introduced in release 4.1.5 was made
a settable global variable. (Bug#5736)
InnoDB: If DROP TABLE is invoked on an
InnoDB table for which the .ibd file is
missing, print to error log that the table was removed from
the InnoDB data dictionary, and allow
MySQL to delete the .frm file. Maybe
DROP TABLE should issue a warning in this
case.
TIMESTAMP columns now can store
NULL values. To create such a column, you
must explicitly specify the NULL
attribute in the column specification. (Unlike all other
column types, TIMESTAMP columns are
NOT NULL by default.)
Now if ALTER TABLE converts one
AUTO_INCREMENT column to another
AUTO_INCREMENT column it preserves zero
values (this includes the case that we don't change such
column at all).
Now if ALTER TABLE converts some column
to TIMESTAMP NOT NULL column it converts
NULL values to current timestamp value
(One can still get old behavior by setting system
TIMESTAMP variable to zero).
On Windows, the MySQL configuration files included in the
package now use .ini instead of
.cnf as the file name suffix.
Bogues corrigés :
Fixed a bug that caused the server to crash on attempt to execute a prepared statement with a subselect inside a boolean expression. (Bug#5987)
Fixed a bug that caused the server to sometimes choose non-optimal execution plan for a prepared statement executed with changed placeholder values. (Bug#6042)
InnoDB: Make the check for excessive semaphore waits tolerate glitches in the system clock (do not crash the server if the system time is adjusted while InnoDB is under load.). (Bug#5898)
InnoDB: Fixed a bug in the InnoDB FOREIGN
KEY parser that prevented ALTER
TABLE of tables containing
‘#’ in their names. (Bug#5856)
InnoDB: Fixed a bug that prevented ALTER TABLE
from working. (Bug#5851)
t DISCARD TABLESPACE
InnoDB: SHOW CREATE TABLE now obeys the
SET SQL_MODE=ANSI and SET
SQL_QUOTE_SHOW_CREATE=0 settings. (Bug#5292)
InnoDB: Fixed a bug that caused CREATE TEMPORARY
TABLE ... ENGINE=InnoDB to terminate
mysqld when running in
innodb_file_per_table mode. Per-table
tablespaces for temporary tables from now on are created in
the temporary directory of mysqld. (Bug#5137)
InnoDB: Fixed some (not all) UTF-8 bugs in column prefix indexes. (Bug#5975)
InnoDB: If one updated a column so that its size changed, or
updated it to an externally stored (TEXT
or BLOB) value, then ANOTHER externally
stored column would show up as 512 bytes of good data + 20
bytes of garbage in a consistent read that fetched the old
version of the row. (Bug#5960)
InnoDB: Change error code to
HA_ERR_ROW_IS_REFERENCED if we cannot
DROP a parent table referenced by a
FOREIGN KEY constraint; this error number
is less misleading than the previous number
HA_ERR_CANNOT_ADD_FOREIGN, but misleading
still. (Bug#6202)
Fixed REVOKE ALL PRIVILEGES, GRANT OPTION FROM
so that all
privileges are revoked correctly. (Bug#5831)
user
Fixed a bug that caused the server to crash when character
set conversion was implicitly used in prepared mode; for
example, as in 'abc' LIKE CONVERT('abc' as
utf8). (Bug#5688)
The mysql_change_user() C API function
now frees all prepared statements associated with the
connection. (Bug#5315)
Fixed a bug when inserting NULL into an
AUTO_INCREMENT column failed, when using
prepared statements. (Bug#5510)
Fixed slave SQL thread so that the SET
COLLATION_SERVER... statements it replicates don't
advance its position (so that if it gets interrupted before
the actual update query, it later redoes the
SET). (Bug#5705)
Fixed that if the slave SQL thread found a syntax error in a query (which should be rare, as the master parsed it successfully), it stops. (Bug#5711)
Fixed that if a write to a MyISAM table
fails because of a full disk or an exceeded disk quota, it
prints a message to the error log every 10 minutes, and
waits until disk space becomes available. (Bug#3248)
Now MySQL does not prefer columns, which are mentioned in
select list but are renamed, over columns from other tables
participating in FROM clause when it
resolves GROUP BY clause (e.g.
SELECT t1.a AS c FROM t1, t2 ORDER BY a
produces an error if both t1 and
t2 tables contain a
column). (Bug#4302)
Behavior of ALTER TABLE converting column
containing NULL values to
AUTO_INCREMENT column is no longer
affected by NO_AUTO_VALUE_ON_ZERO mode.
(Bug#5915).
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.
