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

04/24/2006
MySQL 5.0.20a released.

MySQL 5.0.20a, a new production version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages 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 for more details about the individual bugs fixed in this version.

Changes in release 5.0.20a:

Functionality added or changed:

  • The fix for "Command line options are ignored for mysql client" has been revoked, because it had introduced an incompatible change in the way the command line client ("mysql") selects the server to connect to. In the worst case, this might have led to a client issuing commands to a server for which they were not intended, and this must not happen.
    To help all users in understanding this subject, the manual now includes additional explanations in the section "4.2. Invoking MySQL Programs"
  • The code of the "yaSSL" library has been improved to avoid the dependency on a C++ runtime library, so a link with pure C applications is now possible on further (but not all) platforms. We are trying to fix the remaining issues.

Changes in release 5.0.20:

Functionality added or changed:

  • InnoDB: The InnoDB storage engine now provides a descriptive error message if ibdata file information is omitted from my.cnf.
  • The NDBCluster storage engine now supports INSERT IGNORE and REPLACE statements. Previously, these statements failed with an error.
  • Builds for Windows, Linux, and Unix (except AIX) platforms now have SSL support enabled, in the server as well as in the client libraries. Because part of the SSL code is written in C++, this does introduce dependencies on the system's C++ runtime libraries in several cases, depending on compiler specifics.
  • The syntax for CREATE PROCEDURE and CREATE FUNCTION statements now includes a DEFINER clause. The DEFINER value specifies the security context to be used when checking access privileges at routine invocation time if the routine has the SQL SECURITY DEFINER characteristic. See Section 17.2.1, "CREATE PROCEDURE and CREATE FUNCTION Syntax," for more information. (http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html)

Bugs fixed:

  • Security Fix: Checks for permissions on database operations could be performed in a case-insensitive manner (a user with permissions on database MYDATABASE could by accident get permissions on database myDataBase), if the privilege data were still cached from a previous check.
  • InnoDB: The LATEST FOREIGN KEY ERROR section in the output of SHOW INNODB STATUS was sometimes formatted incorrectly, causing problems with scripts that parsed the output of this statement.

twitterfacebook