Fixed a bug : if you updated a row so that the 8000 byte
maximum length (without BLOB
and
TEXT
) was exceeded, InnoDB simply removed
the record from the clustered index. In a similar insert,
InnoDB would leak reserved file space extents, which would
only be freed at the next mysqld startup.
Fixed a bug : if you used big BLOB
values, and your log files were relatively small, InnoDB
could in a big BLOB
operation temporarily
write over the log produced after the latest checkpoint. If
InnoDB would crash at that moment, then the crash recovery
would fail, because InnoDB would not be able to scan the log
even up to the latest checkpoint. Starting from this
version, InnoDB tries to ensure the latest checkpoint is
young enough. If that is not possible, InnoDB prints a
warning to the .err
log of MySQL and
advises you to make the log files bigger.
Fixed a bug : setting
innodb_fast_shutdown=0
had no effect.
Fixed a bug introduced in 4.0.13: if a CREATE
TABLE
ended in a comment, that could cause a
memory overrun.
Fixed a bug : If InnoDB printed Operating system
error number .. in a file operation
to the
.err
log in Windows, the error number
explanation was wrong. Workaround: look at section 13.2 of
http://www.innodb.com/ibman.php about Windows error numbers.
Fixed a bug : If you created a column prefix
PRIMARY KEY
like in t(a
CHAR(200), PRIMARY KEY (a(10)))
on a fixed-length
CHAR
column, InnoDB would crash even in a
simple SELECT
. CCHECK
TABLE
would report the table as corrupt, also in
the case where the created key was not
PRIMARY
.
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.