In INSERT INTO t1 SELECT ... FROM t2 WHERE ... MySQL previously set a table level read lock on t2. This lock is now removed.
Increased SHOW INNODB STATUS maximum printed length to 200KB.
Fixed a major bug in
optimization: queries of type SELECT ... WHERE indexcolumn
< x and SELECT ... WHERE indexcolumn > x could cause a
table scan even if the selectivity would have been very good.
Fixed a bug: purge could cause a hang in a BLOB table where the primary key index tree was of height 1. Symptom: semaphore waits caused by an X-latch set in btr_free_externally_stored_field().
Fixed a bug: using
InnoDB HANDLER commands
on a fresh handle crashed mysqld in
Fixed a bug: If MySQL estimated a query in the middle of a
InnoDB could hang on the
adaptive hash index latch in btr0sea.c.
Fixed a bug:
InnoDB could report table
corruption and assert in page_dir_find_owner_slot() if an
adaptive hash index search coincided with purge or an insert.
Fixed a bug: some file system snapshot tool in Windows 2000
could cause an
InnoDB file write to fail
with error 33 ERROR_LOCK_VIOLATION. In synchronous writes
InnoDB now retries the write 100 times at 1
Fixed a bug:
REPLACE INTO t1 SELECT ... did
not work if t1 has an
An outstanding bug:
SET foreign_key_checks =
0 is not replicated properly in the MySQL