Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL 4.0.17 (production) Has Been Released

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

MySQL 4.0.17, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ (http://www.mysql.com/downloads/) and mirror sites.

Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site.

This is a bugfix release for the current production version.

Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version.

News from the ChangeLog:

Functionality added or changed:

* `mysqldump' no longer dumps data for `MERGE' tables. (Bug #1846)

* `lower_case_table_names' is now forced to 1 if the database directory is located on a case-insensitive file system. (Bug #1812)

* Symlink creation is now disabled on systems where `realpath()' doesn't work. (Before one could use `CREATE TABLE .. DATA DIRECTORY=..' even if `HAVE_BROKEN_REALPATH' was defined. This is now disabled to avoid problems when running `ALTER TABLE').

* Inserting a negative `AUTO_INCREMENT' value in a `MyISAM' table no longer updates the `AUTO_INCREMENT' counter to a big unsigned value. (Bug #1366)

* Added four new modes to `WEEK(..., mode)' function. *Note `WEEK(date,mode)': Date and time functions. (Bug #1178)

* Allow `UNION DISTINCT' syntax.

* `mysql_server_init()' now returns 1 if it can't initialize the environment. (Previously `mysql_server_init()' called `exit(1)' if it could not create a key with `pthread_key_create()'. (Bug #2062)

* Allow spaces in Windows service names.

* Changed the default Windows service name for `mysqld' from `MySql' to `MySQL'. This should not affect usage, because service names are not case sensitive.

* When you install `mysqld' as a service on Windows systems, `mysqld' will read startup options in option files from the option group with the same name as the service name. (Except when the service name is `MySQL').

Additional notes:

- In addition to RPMs for Linux/x86 and Linux/AMD64, we now also provide RPM packages for Linux/IA64. These are optimized to run on Linux with Itanium 2 processors, but should run on Itanium 1 systems as well. They are built on Red Hat Linux AS 2.1.

- Our Mac OS X build host has been upgraded to Mac OS X 10.2.8 (darwin6.8)

- Our FreeBSD/sparc64 build host has been upgraded to FreeBSD 5.1