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.