MariaDB 10.0.4 Release Notes

The most recent release in the MariaDB 10.0 series is:MariaDB 10.0.38 Download Now

Download | Release Notes | Changelog | Overview of 10.0

Release date: 16 Aug 2013

MariaDB 10.0 is the current development version of MariaDB. It is built on the MariaDB 5.5 series with backported and reimplemented features from MySQL 5.6 and entirely new features not found anywhere else.

MariaDB 10.0.4 is an Alpha release. This is the fifth 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases.Do not use alpha releases on production systems.

For an overview of MariaDB 10.0 see theWhat is MariaDB 10.0? page.

For a list of changes made in , with links to detailed information on each push, see the .

Based on

The series builds off of the series. It also includes features imported from MySQL 5.6, and completely new features.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB.

Security fixes

This release includes fixes for the following security vulnerabilities:

Newly Implemented Features

• -

• - Port Percona response time distribution as audit plugin

• - Reduce usage of LOCK_open

Features and Fixes Merged or Backported from MySQL 5.6.10

• - Support for MySQL-5.6 created tables (frm and data files) that have columns of types TIME(N), DATETIME(N) and TIMESTAMP(N). Previously, an attempt to open such a table in MariaDB would return an error.

• - Support for standard SQL temporal literals

• - Merge the

• WL #5185 Remove deprecated 5.1 features

For full details, see the .

Updates

New features added to CONNECT

1. The connection parameter of MYSQL type tables and PROXY tables on MySQL tables can now refer to a server.

2. The SERVID special column is now implemented. It returns the Federated server name for tables using one, the host name of the server for MYSQL tables, "ODBC" for ODBC tables and "Current" for all other table types. For PROXY and PROXY based tables, this value is the one of the source proxied table(s).

Modifications to CONNECT Behavior

1. Table locking (read and write) is now supported. When a table is write locked, indexes are not updated on table changes. They are when the table is unlocked. Consequently, SELECT statements do not use indexing while locked.

2. CONNECT no longers uses the query cache. This is because it is working on external data which is prone to be modified outside of MariaDB (it was also causing a crash with PIVOT tables)

Modifications to CONNECT Error messages

Some messages were changed from error to warning to prevent a server crash. Some have been added, in particular:

1. When trying to index a null-able column (not supported yet)

2. When inserting on an INI table without specifying the sectio name.

3. When specifying ENUM column (not supported yet)

4. Better message for CONNECT unspported commands

CONNECT Engine Bugs fixed:

A few bugs were fixed, in particular:

• : Unsupported use of nullable column for index is not caught, causes assertion failure or unspecified error (122)

• : Assertion failure in Diagnostics_area::set_error_status or unspecified error instead of a duplicate key error

• : Server crashes when querying from multiple file CONNECT table

• : Server crashes with an indexed not-null ENUM column

Other Features

Other features are planned for inclusion in the . They are listed on the and Plans for 10x pages.

Thanks, and enjoy MariaDB!