This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-21. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 10.2.0 Release Notes

The most recent release of MariaDB 10.2 is:
MariaDB 10.2.44 Stable (GA) Download Now

Download Release Notes Changelog Overview of 10.2

Release date: 18 Apr 2016

MariaDB 10.2 is the current development series of MariaDB. It is an evolution of MariaDB 10.1 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.

MariaDB 10.2.0 is an Alpha release.

Do not use alpha releases on production systems!

For an overview of MariaDB 10.2 see the What is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

This is the first alpha release in the MariaDB 10.2 series.

Notable changes of this release include:

Syntax:

  • Window functions have been introduced. This release adds support for a limited set of functions, and the basic execution algorithm. Development continues to expand the set of supported functions and optimize the execution.
  • The SHOW CREATE USER statement was introduced.
  • New CREATE USER options for limiting resource usage and tls/ssl.
  • New ALTER USER statement.
  • New reserved-words: OVER and RECURSIVE. These can no longer be used as identifier-names without being quoted.

Scripts:

Information Schema:

Variables:

EXPLAIN:

  • EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY clause or Distinct. This is a long-standing problem coming from MySQL. Now, after MDEV-8646 and related fixes, the problem doesn't exist anymore. (For testcases, see MDEV-7982, MDEV-8857, MDEV-7885)

Optimizations:

  • Connection setup was made faster by moving creation of THD to new thread (MDEV-6150)

Code:

  • "fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - MDEV-8111.

Notes

Do not use alpha releases on production systems!

  • Repositories exist for 10.2, but because 10.2 is still alpha, it is not visible in the repository configuration tool. To configure a 10.2 apt, yum, or zypper repository using the tool, simply select 10.1 and then when executing the instructions, change all occurrences of '10.1' to '10.2'.
  • MDEV-9781 - APT 1.2.7 (and later) prefers SHA2 GPG keys and now prints warnings when a repository is signed using a SHA1 key. We have created a new SHA2 key for use with our Debian "sid" repository. When we add an Ubuntu 16.04 "xenial" repository, it will also use this new key.
    • The Key ID is: C74CD1D8
    • The full fingerprint of the new key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
    • The key can be added using the following command:
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

Changelog

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


Be notified of new MariaDB Server releases automatically by subscribing 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 page.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.