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.
Changed copyright for all files to GPL for the server code and utilities and to LGPL for the client libraries. See http://www.fsf.org/licenses/.
Fixed bug where all rows matching weren't updated on a
MyISAM table when doing update based on key
on a table with many keys and some key changed values.
The Linux MySQL RPMs and binaries are now statically linked with a linuxthread version that has faster mutex handling when used with MySQL.
ORDER BY can now use
keys to find subsets of the rows that need to be sorted.
Changed name of print_defaults program to my_print_defaults to avoid name confusion.
NULLIF() to work as
required by standard SQL.
Fixed bug that destroyed index when doing myisamchk --sort-records on a table with prefix compressed index.
Added pack_isam and myisampack to the standard MySQL distribution.
Fixed core dump bug when using
ORDER BY on
LOAD TABLE FROM MASTER.
Fixed big/little endian problem in the replication.