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

06/01/2005
MySQL 5.0.6-beta released.

A new version of MySQL Community Edition 5.0.6-beta 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 second Beta release in the 5.0 series. All attention will now be focused on fixing bugs and stabilizing 5.0 for later production release.

NOTE: This Beta release, as any other pre-production release, should not be installed on ``production'' level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has done its best to ensure a high level of quality, protect your data by making a backup as you would for any software beta 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.6:

Functionality added or changed:

  • INCOMPATIBLE CHANGE: `MyISAM' and `InnoDB' tables created with `DECIMAL' columns in MySQL 5.0.3 to 5.0.5 will appear corrupt after an upgrade to MySQL 5.0.6. Dump such tables with `mysqldump' before upgrading, and then reload them after upgrading. (The same incompatibility will occur for these tables created in MySQL 5.0.6 after a downgrade to MySQL 5.0.3 to 5.0.5.)
  • Added `REFERENCED_TABLE_SCHEMA', `REFERENCED_TABLE_NAME', and `REFERENCED_COLUMN_NAME' columns to the `KEY_COLUMN_USAGE' table of `INFORMATION_SCHEMA'.
  • Added a `--show-warnings' option to `mysql' to cause warnings to be shown after each statement if there are any. This option applies to interactive and batch mode. In interactive mode, `\\w' and `\\W' may be used to enable and disable warning display.
  • Removed a limitation that prevented use of FIFOs as logging targets (such as for the general query log). This modification _does not apply_ to the binary log and the relay log.

Bugs fixed:

  • `MERGE' tables could fail on Windows due to incorrect interpretation of pathname separator characters for filenames in the `.MRG' file.
  • Fixed a server crash for `INSERT ... ON DUPLICATE KEY UPDATE' with `MERGE' tables, which do not have unique indexes.
  • Fix `FORMAT()' to do better rounding for double values (for example, `FORMAT(4.55,1)' returns `4.6', not `4.5').
  • Disallow use of `SESSION' or `GLOBAL' for user variables or local variables in stored routines.
  • Fixed a server crash when using `GROUP BY ... WITH ROLLUP' on an indexed column in an `InnoDB' table.
  • In strict SQL mode, some assignments to numeric columns that should have been rejected were not (such as the result of an arithmetic expression or an explicit `CAST()' operation).
  • Fixed a server crash in the `BLACKHOLE' storage engine.
  • Fixed a server crash resulting from repeated calls to `ABS()' when the argument evaluated to `NULL'.
  • Fixed a server crash resulting from a `CHECK TABLE' statement where the arguments were a view name followed by a table name.

And many more...

Source: dev.mysql.com

twitterfacebook