> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/10.0.18.md).

# MariaDB 10.0.18 Release Notes

The most recent release in the [MariaDB 10.0](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) series is:[**MariaDB 10.0.38**](/docs/release-notes/community-server/old-releases/10.0/10.0.38.md) [Download Now](https://downloads.mariadb.org/mariadb/10.0.38)

[Download](https://downloads.mariadb.org/mariadb/10.0.18) | [Release Notes](/docs/release-notes/community-server/old-releases/10.0/10.0.18.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-100-series/mariadb-10018-changelog.md) | [Overview of 10.0](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md)

**Release date:** 7 May 2015

[MariaDB 10.0](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) is the current stable series of MariaDB. It is an evolution of [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) with several entirely new features not found anywhere else and with\
backported and reimplemented features from MySQL 5.6.

[MariaDB 10.0.18](/docs/release-notes/community-server/old-releases/10.0/10.0.18.md) is a [***Stable***](/docs/release-notes/community-server/about/release-criteria.md) (*GA*) release.

**For an overview of** [**MariaDB 10.0**](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) **see the**[**What is MariaDB 10.0?**](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) **page.**

Thanks, and enjoy MariaDB!

## Notable changes

In addition to the [MariaDB-5.5.43](/docs/release-notes/community-server/old-releases/5.5/5.5.43.md) fixes and improvements, the following fixes and improvements have been made to [MariaDB 10.0.18](/docs/release-notes/community-server/old-releases/10.0/10.0.18.md).

* [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) updated to 5.6.24
* [XtraDB](/docs/server/server-usage/storage-engines/innodb.md) updated to XtraDB-5.6.23-72.1
* [Innodb](/docs/server/server-usage/storage-engines/innodb.md) updated to InnoDB-5.6.24
* [Spider](/docs/server/server-usage/storage-engines/spider.md) updated to 3.2.21
* [Mroonga](/docs/server/server-usage/storage-engines/mroonga.md) updated to 5.02
* [Audit Plugin](/docs/server/reference/plugins/mariadb-audit-plugin.md) upgraded to 1.3.0, including the QUERY\_DCL filter option.

### Parser

* Fixed unrecognised column quoted with backticks in a function in a HAVING clause ([MDEV-7301](https://jira.mariadb.org/browse/MDEV-7301)).
* [ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) with conflicting CHARACTER SET and CONVERT TO CHARACTER SET arguments now reports error ([MDEV-7386](https://jira.mariadb.org/browse/MDEV-7386)).
* Fixed Regression (from 10.0.14): Bit and hex string literals changed column names ([MDEV-7629](https://jira.mariadb.org/browse/MDEV-7629)).

### Optimizer

* Merged [derived tables](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables.md)/VIEWs incorrectly increment [created\_tmp\_tables](/docs/server/server-management/variables-and-modes/server-status-variables.md#created_tmp_tables) ([MDEV-7586](https://jira.mariadb.org/browse/MDEV-7586)).

### Alter Table

* Some symbols in table name can cause to Error Code: 1050 when created FK. Table name is on filename charset but foreign key identifiers are not. This lead incorrect foreign key identifier number to be used ([MDEV-7627](https://jira.mariadb.org/browse/MDEV-7627)).
* [ALTER \[ONLINE\] TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) with no options no longer requires a table copy ([MDEV-7390](https://jira.mariadb.org/browse/MDEV-7390)).
* Fixed a case where it was impossible to create copy of a table if the table contained a default value for timestamp field in [sql\_mode](/docs/server/server-management/variables-and-modes/sql_mode.md)="NO\_ZERO\_DATE" ([MDEV-7778](https://jira.mariadb.org/browse/MDEV-7778)).

### Other SQL Commands

* [INSTALL PLUGIN](/docs/server/reference/sql-statements/administrative-sql-statements/plugin-sql-statements/install-plugin.md) can now be done in bootstrap mode where authentication is disabled ([MDEV-7781](https://jira.mariadb.org/browse/MDEV-7781)).
* Corrected error handing in [AES\_ENCRYPT](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/aes_encrypt.md)/[AES\_DECRYPT](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/aes_decrypt.md) where incorrect data could result in a SSL client connection being terminated ([MDEV-7697](https://jira.mariadb.org/browse/MDEV-7697)).
* Corrected Assertion \`status\_var.memory\_used == 0' failed in THD::THD() on disconnect after executing [EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md) for multi-table [UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md) ([MDEV-7038](https://jira.mariadb.org/browse/MDEV-7038)).
* Fixed crash when dropping user within rebuild\_role\_grants which occurs in some cases in [SHOW GRANTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants.md) and [DROP ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/drop-role.md) ([MDEV-7774](https://jira.mariadb.org/browse/MDEV-7774)).
* [SHOW GRANTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants.md) now shows the password for users that have the password field set, auth\_string field empty, plugin=mysql\_native\_password ([MDEV-7985](https://jira.mariadb.org/browse/MDEV-7985)).

### Innodb

* In Debug builds, an assertion could be triggered on really large blobs ([MDEV-7754](https://jira.mariadb.org/browse/MDEV-7754)).
* Fixed segfault when a virtual column used on an Innodb table and an index was created on a field after the virtual column ([MDEV-7367](https://jira.mariadb.org/browse/MDEV-7367)).
* Fixed server crash when inserting more rows than available space on disk ([MDEV-7685](https://jira.mariadb.org/browse/MDEV-7685)).
* Now possible to get Innodb internal primary key for wrapper type storage engines ([MDEV-7714](https://jira.mariadb.org/browse/MDEV-7714)).

### Replication

* Starting with this release, commits in certain instances in parallel replication complete immediately, avoiding losing throughput when many transactions need conflicting locks. See [binlog\_commit\_wait\_count](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md) ([MDEV-7847](https://jira.mariadb.org/browse/MDEV-7847) / [MDEV-7882](https://jira.mariadb.org/browse/MDEV-7882)).
* Fixed parallel replication worker threads that hung in some cases with non-transactional event groups ([MDEV-7929](https://jira.mariadb.org/browse/MDEV-7929)).
* Fixed parallel replication error where deadlock was incorrectly handled ([MDEV-8031](https://jira.mariadb.org/browse/MDEV-8031)).
* Fixed replication aborting on [DROP /\*!40005 TEMPORARY \*/ TABLE IF EXISTS](/docs/server/server-usage/tables/drop-table.md) ([MDEV-8016](https://jira.mariadb.org/browse/MDEV-8016)).
* Fixed replication of temporary tables in statement mode that are grouped - fix [MDEV-7668](https://jira.mariadb.org/browse/MDEV-7668) wasn't sufficient ([MDEV-7936](https://jira.mariadb.org/browse/MDEV-7936)).
* Fixed [ANALYZE TABLE](/docs/server/reference/sql-statements/table-statements/analyze-table.md) which was ordered incorrectly in the binlog ([MDEV-7888](https://jira.mariadb.org/browse/MDEV-7888)).
* Added more detailed information about errors when GTID mode IO threads fail to connect ([MDEV-7975](https://jira.mariadb.org/browse/MDEV-7975)).
* Fixed temporary tables lost at [STOP SLAVE](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/stop-replica.md) in GTID mode if master has not rotated binlog since restart ([MDEV-6403](https://jira.mariadb.org/browse/MDEV-6403)).
* Fixed incorrect relay log start position when restarting SQL thread after error in parallel replication ([MDEV-6589](https://jira.mariadb.org/browse/MDEV-6589)).
* Fixed problem where slave was 10x slower to execute a set of statements compared to the master when using RBR ([MDEV-7578](https://jira.mariadb.org/browse/MDEV-7578)).
* Parallel replication worker threads are not spawned until needed (when an SQL thread is started), and they will be de-spawned if all SQL threads are stopped ([MDEV-5289](https://jira.mariadb.org/browse/MDEV-5289)).
* Multilevel slaves with parallel replication - better logic resulted in performance increase to group more transactions at the first slave level resulting in increased parallelism at the second replication level ([MDEV-7249](https://jira.mariadb.org/browse/MDEV-7249)).
* Fixed problem where Intermediate master groups using [CREATE TEMPORARY TABLE](/docs/server/server-usage/tables/create-table.md) with [INSERT](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert.md) could cause the [INSERT](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert.md) to occur before the TEMPORARY TABLE it operates on, causing parallel replication failure ([MDEV-7668](https://jira.mariadb.org/browse/MDEV-7668)).
* Slave SQL: stopping replication on a non-last RBR event with annotations no longer results in segfaults ([MDEV-7864](https://jira.mariadb.org/browse/MDEV-7864)).
* [MASTER\_POS\_WAIT(log\_name,log\_pos,timeout,"connection\_name")](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/master_pos_wait.md) when connection name is specified now respects the timeout ([MDEV-7130](https://jira.mariadb.org/browse/MDEV-7130)).
* New status variables [binlog\_group\_commit\_trigger\_count](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md#binlog_group_commit_trigger_count), [binlog\_group\_commit\_trigger\_timeout](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md#binlog_group_commit_trigger_timeout), and [binlog\_group\_commit\_trigger\_lock\_wait](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md#binlog_group_commit_trigger_lock_wait) used to examine which triggers caused a group commit to be made ([MDEV-7802](https://jira.mariadb.org/browse/MDEV-7802)).
* Fixed seconds\_behind\_master display in [SHOW SLAVE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-status.md) which occasionally returned 0 when it really was much higher ([MDEV-5114](https://jira.mariadb.org/browse/MDEV-5114)).

### Platforms

* PowerPC - fixed Innodb locking issue under high load - ([MDEV-7148](https://jira.mariadb.org/browse/MDEV-7148)).
* BigEndian now builds in [Cassandra](/docs/server/server-usage/storage-engines/legacy-storage-engines/cassandra.md) storage engine ([MDEV-7839](https://jira.mariadb.org/browse/MDEV-7839)).
* Fixed crash when running MariaDB Debug with InnoDB on Windows ([MDEV-8079](https://jira.mariadb.org/browse/MDEV-8079)).

### Connect Engine

* [CONNECT Engine](/docs/server/server-usage/storage-engines/connect.md) Column names are now retrieved properly when field values are not latin1 characters ([MDEV-7521](https://jira.mariadb.org/browse/MDEV-7521)).
* Fixed problem where connecting to missing remote table caused error that was re-reported when [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md) on a correctly formed table ([MDEV-7636](https://jira.mariadb.org/browse/MDEV-7636)).
* Fixed problem where CONNECT returned error 174 on query to MS SQL Server 2012 involving [timestamp](/docs/server/reference/data-types/date-and-time-data-types/timestamp.md) column when the condition is given as a [date literal](/docs/server/reference/sql-structure/sql-language-structure/date-and-time-literals.md) ([MDEV-7840](https://jira.mariadb.org/browse/MDEV-7840)).
* CONNECT now works with if(exists(select \* from test)) statement in procedures ([MDEV-7852](https://jira.mariadb.org/browse/MDEV-7852)).
* Fixed user variable assignment with SET @var = that resulted in ERROR 1148 (42000): CONNECT Unsupported command ([MDEV-7616](https://jira.mariadb.org/browse/MDEV-7616)).
* Removed assertion in delete\_or\_rename\_table that caused crashes on (XML) HTML tables ([MDEV-7935](https://jira.mariadb.org/browse/MDEV-7935)).
* Added UDF [Json\_Array\_Delete](/docs/server/server-usage/storage-engines/connect/connect-table-types/connect-json-table-type.md) ([MDEV-7935](https://jira.mariadb.org/browse/MDEV-7935)).
* Fixed a problem where defining indexes on a connect engine caused wrong results ([MDEV-8090](https://jira.mariadb.org/browse/MDEV-8090)).

### OQ Graph Engine

* Fixed issue with incorrect handling of multiple threads ([MDEV-6282](https://jira.mariadb.org/browse/MDEV-6282), [MDEV-6345](https://jira.mariadb.org/browse/MDEV-6345) and [MDEV-6784](https://jira.mariadb.org/browse/MDEV-6784)).

### Other

* SSL connections increased from 512 to 1024 bits in Diffie-Hellman exchange to support fips ([MDEV-7794](https://jira.mariadb.org/browse/MDEV-7794)).
* Fixed problem where SSL read/write timeouts were 1000 times too high due to seconds/milliseconds error ([MDEV-8096](https://jira.mariadb.org/browse/MDEV-8096)).
* OpenSSL now uses MD5 even if FIPS prohibited it, fixing a previous crash. This is fine as MD5 is not used for cryptographical\
  purposes (md5 is used internally for P\_S message digests and for view checksums) ([MDEV-7788](https://jira.mariadb.org/browse/MDEV-7788)).
* Fixed problem where Initialization of status variables was not invoked for embedded (no bug reference. [code change](https://github.com/MariaDB/server/commit/e6d918cacba8c5f3b002c4eb0244f44c3c941818))
* Corrected wrong results with bigint when compiled with gcc 5.0 ([MDEV-7973](https://jira.mariadb.org/browse/MDEV-7973)).
* Fixed assertion in Protocol::end\_statement where [CREATE VIEW](/docs/server/server-usage/views/create-view.md) occured after another connection aborted ([MDEV-8045](https://jira.mariadb.org/browse/MDEV-8045)).

### Client

* Fixed MariaDB client where it could hang in an infinite loop based on no IO data returned ([MDEV-8014](https://jira.mariadb.org/browse/MDEV-8014)).

### Security Fixes

* Fixes for the following [security vulnerabilities](/docs/server/security/cve.md):
  * [CVE-2014-8964](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-8964) / [CVE-2015-2325](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-2325) / [CVE-2015-2326](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-2326) bundled PCRE contained heap-based buffer overflow vulnerability that allowed the server to crash or have other unspecified impact via a crafted regular expression made possible with the [REGEXP\_SUBSTR](/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_substr.md) function ([MDEV-8006](https://jira.mariadb.org/browse/MDEV-8006)).
  * [CVE-2015-0501](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-0501)
  * [CVE-2015-2571](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-2571)
  * [CVE-2015-0505](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-0505)
  * [CVE-2015-0499](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-0499)
  * [CVE-2015-4757](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-4757)
  * [CVE-2015-4866](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-4866)

### New and Deprecated Distributions

As per the [MariaDB Deprecation Policy](/docs/release-notes/community-server/about/platform-deprecation-policy.md), this will\
be the final release of [MariaDB 10.0](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) for Fedora 19 "Schrödinger's Cat", Ubuntu\
10.04 LTS "Lucid", and Mint 9 LTS "Isadora". When the next\
version of [MariaDB 10.0](/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0.md) is released, repositories for these distributions will\
go away.

We have also added a couple of new Linux distributions with this release. Both\
Fedora 21 and Ubuntu 15.04 "Vivid" repositories are now available. As this is\
the first release with these repositories, they are considered experimental.\
Please [let us know](https://mariadb.org/jira) if you run into any issues with\
them.

For a complete list of changes made in [MariaDB 10.0.18](/docs/release-notes/community-server/old-releases/10.0/10.0.18.md), with links to detailed\
information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-100-series/mariadb-10018-changelog.md).

{% hint style="info" %}
Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the [Distributions which Include MariaDB](/docs/general-resources/distributions-including-mariadb.md) page.
{% endhint %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}