MySQL/InnoDB-4.0.15, September 10, 2003
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 bigBLOB
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 MariaDB 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 int(a CHAR(200), PRIMARY KEY (a(10)))
on a fixed-lengthCHAR
column, InnoDB would crash even in a simpleSELECT
. CCHECK TABLE
would report the table as corrupt, also in the case where the created key was notPRIMARY
.