Removed unnecessary deadlocks when inserts have to wait for a locking read, update, or delete to release its next-key lock.
The MySQL HANDLER SQL commands now work
also for InnoDB type tables.
InnoDB does the
HANDLER reads always as consistent reads.
HANDLER is a direct access path to read
individual indexes of tables. In some cases
HANDLER can be used as a substitute of
server-side cursors.
Fixed a bug in 4.0.2: even a simple insert could crash the AIX version.
Fixed a bug : if you used in a table name characters whose code is > 127, in DROP TABLE InnoDB could assert on line 155 of pars0sym.c.
Compilation from source now provides a working version both on HP-UX-11 and HP-UX-10.20. The source of 4.0.2 worked only on 11, and the source of 3.23.52 only on 10.20.
Fixed a bug : if compiled on 64-bit Solaris, InnoDB produced a bus error at startup.
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.
