EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

SQL Industry News

MySQL News

01/10/2006
MySQL 5.0.18 released

MySQL 5.0.18, a new GA/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.18:

Functionality added or changed:

  • It is now possible to build the server such that MyISAM tables can support up to 128 keys rather than the standard 64. This can be done by configuring the build using the option --with-max-indexes=N, where N<=128 is the maximum number of indexes to permit per table.
  • The server treats stored routine parameters and local variables (and stored function return values) according to standard SQL. Previously, parameters, variables, and return values were treated as items in expressions and were subject to automatic (silent) conversion and truncation. Now the data type is observed. Data type conversion and overflow problems that occur in assignments result in warnings, or errors in strict mode. The CHARACTER SET clause for character data type declarations is used. Parameters, variables, and return values must be scalars; it is no longer possible to assign a row value. Also, stored functions execute using the sql_mode value in force at function creation time rather than ignoring it. For more information, see Section 17.2.1, "CREATE PROCEDURE and CREATE FUNCTION."

Bugs fixed:

  • SHOW [FULL] COLUMNS and SHOW INDEX FROM did not function with temporary tables.
  • The INFORMATION_SCHEMA.COLUMNS table did not report the size of BINARY or VARBINARY columns.
  • The server would not compile under Cygwin.
  • DESCRIBE did not function with temporary tables.
  • Reversing the order of operands in a WHERE clause testing a simple equality (such as WHERE t1.col1 = t2.col2) would produce different output from EXPLAIN.
  • Column aliases were displayed incorrectly in a SELECT from a view following an update to a base table of the view.
  • Prior versions did not allow the use of set functions which were aggregated in an outer [sub]query, this did not comply with the standard. Now this limitation is lifted. Moreover, the use of nested set functions is now supported. For more information, see a detailed comment in the bug database entry.
  • When a connection using yaSSL was aborted, the server would continue to try to read the closed socket, and the thread continued to appear in the output of SHOW PROCESSLIST. Note that this issue did not affect secure connection attempts using OpenSSL.
  • InnoDB: Having two tables in a parent-child relationship enforced by a foreign key where one table used ROW_FORMAT=COMPACT and the other used ROW_FORMAT=REDUNDANT could result in a MySQL server crash. Note that this problem did not exist prior to MySQL 5.0.3, when the compact row format for InnoDB was introduced.
  • BDB: A DELETE, INSERT, or UPDATE of a BDB table could cause the server to crash where the query contained a subquery using an index read.
  • A left join on a column that having a NULL value could cause the server to crash.
  • A replication slave server could sometimes crash on a BEFORE UPDATE trigger if the UPDATE query was not executed in the same database as the table with the trigger.
  • A race condition when creating temporary files caused a deadlock on Windows with threads in Opening tables or Waiting for table states.

And many more...

Source: dev.mysql.com

twitterfacebook