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

MySQL 5.1.5-alpha released.

MySQL 5.1.5, a new 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 new alpha development release, adding new features and fixing recently discovered bugs.

NOTE: This Alpha release, as any other pre-production release, should not be installed on ``production'' level systems or systems with critical data.

Please refer to our bug database for more details about the individual bugs fixed in this version.

Changes in release 5.1.5:

Functionality added or changed:

  • Added the XML functions ExtractValue() and UpdateXML(). ExtractValue() returns the content of a fragment of XML matching a given XPath expression. UpdateXML() replaces the element selected from a fragment of XML by an XPath expression supplied by the user with a second XML fragment (also user-supplied), and returns the modified XML. See Section 12.9, "XML Functions."
  • Added the --base64-output option to mysqlbinlog to print all binary log entries using base64 encoding. This is for debugging only. Logs produced using this option should not be applied on production systems.
  • Added the --port-open-timeout option to mysqld to control how many seconds the server should wait for the TCP/IP port to become free if it cannot be opened.
  • Two new Hungarian collations are included: utf8_hungarian_ci and ucs2_hungarian_ci. These support the correct sort order for Hungarian vowels. However, they do not support the correct order for sorting Hungarian consonant contractions; this issue will be fixed in a future release.
  • Plugins can now have status variables, that are shown in SHOW STATUS.

Bugs fixed:

  • InnoDB: Comparison of indexed VARCHAR CHARACTER SET ucs2 COLLATE ucs2_bin columns using LIKE could fail.
  • Creating a trigger caused a server crash if the table or trigger database was not known because no default database had been selected.
  • Issuing a DROP USER command could cause some users to encounter a hostname is not allowed to connect to this MySQL server error.
  • The --plugin_dir option was not working. Also fix error with specifying parser name for fulltext.
  • Attempting to insert into a table partitioned by LIST a value less than any specified in one of the table's partition definitions resulted in a server crash. In such cases, mysqld now returns ERROR 1500 (HY000): Table has no partition for value v, where v is the out-of-range value.

Additional notes:

The Windows package, "mysql-noinstall-5.1.5-alpha-win32.zip", contains just the "mysqld-max.exe" and "mysqld-max-nt.exe" binaries; because "mysqld.exe", "mysqld-nt.exe", and "mysqld-debug.exe" have not been built for this version. If you previously used one of the latter binaries, you may need to adapt your settings.

Source: dev.mysql.com