End of Product LifecycleActive 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).
ALL in group functions.
Added support for some new
INNER JOIN and
JOIN syntaxes. For example,
* 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
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
Fixed bug in updating
columns with long strings.
Fixed integer-wraparound when giving big integer (>= 10
digits) to function that requires an unsigned argument, like
CREATE TABLE (...)
MIN(key_column) could in some
NULL on a column with
NULL and other values.
Fixed rare crash in compressed
tables with blobs.
When running with
(default on Windows) and you had tables or databases with
mixed case on disk, then executing
TABLE STATUS followed with
TABLE could fail with