End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Functionality added or changed:
NULL is now sorted LAST if you use
ORDER BY ... DESC (as it was before MySQL 4.0.2). This change was required to comply with the SQL standard. (The original change was made because we thought that standard SQL required
NULL to be always sorted at the same position, but this was incorrect).
START TRANSACTION (standard SQL syntax) as alias for
BEGIN. This is recommended to use instead of
BEGIN to start a transaction.
OLD_PASSWORD() as a synonym for
ALL in group functions.
Added support for some new
INNER JOIN and
JOIN syntaxes. For example,
SELECT * FROM t1 INNER JOIN t2 didn't work before.
Novell NetWare 6.0 porting effort completed, Novell patches merged into the main source tree.
Fixed problem with multiple-table delete and
Fixed a problem with
BLOB NOT NULL columns used with
Re-added missing pre- and post(un)install scripts to the Linux RPM packages (they were missing after the renaming of the server subpackage).
Fixed that table locks are not released with multiple-table updates and deletes with
InnoDB storage engine.
Fixed bug in updating
BLOB columns with long strings.
Fixed integer-wraparound when giving big integer (>= 10 digits) to function that requires an unsigned argument, like
CREATE TABLE (...) AUTO_INCREMENT=.
MIN(key_column) could in some cases return
NULL on a column with
NULL and other values.
MAX(key_column) could in some cases return incorrect values when used in
MAX(key_column) could return incorrect values if one of the tables was empty.
Fixed rare crash in compressed
MyISAM tables with blobs.
Fixed bug in using aggregate functions as argument for
When running with
--lower-case-table-names (default on Windows) and you had tables or databases with mixed case on disk, then executing
SHOW TABLE STATUS followed with
DROP DATABASE or
DROP TABLE could fail with