EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

SQL Industry News

All SQL News

09/27/2005
MySQL 5.0 first Release Candidate is out.

A new version of the popular Open Source Database Management System has been released. This version now includes support for Stored Procedures, Triggers, Views and many other features. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites.

Note that not all mirror sites may be up-to-date at this point. If you cannot find this version on a particular mirror, please try again later or choose another download site.

This is the first published release candidate (previously known as "gamma release") in the 5.0 series. All attention will continue to be focused on fixing bugs and stabilizing 5.0 for the upcoming production release.

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

Changes in release 5.0.13:

Functionality added or changed:

  • Better detection of connection timeout for replication servers on Windows allows elimination of extraneous Lost connection errors in the error log.
  • The restriction on the use of PREPARE, EXECUTE, and DEALLOCATE PREPARE within stored procedures was lifted. The restriction still applies to stored functions and triggers.
  • OPTIMIZE TABLE and HANDLER now are prohibited in stored procedures and functions and in triggers.
  • InnoDB: The TRUNCATE TABLE statement for InnoDB tables always resets the counter for an AUTO_INCREMENT column now, regardless of whether there is a foreign key constraint on the table. (Beginning with 5.0.3, TRUNCATE TABLE reset the counter, but only if there was no such constraint.)
  • The LEAST() and GREATEST() functions used to return NULL only if all arguments were NULL. Now they return NULL if any argument is NULL, the same as Oracle.
  • Two new collations have been added for Esperanto: utf8_esperanto_ci and ucs2_esperanto_ci.

And many more...

Source: dev.mysql.com

twitterfacebook