MariaDB 10.2.0 Release Notes

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.

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:

• Continuous binary log backup has been added to mysqlbinlog - MDEV-8713.
• mysql_zap and mysqlbug have been removed - MDEV-7376, MDEV-8654.

Information Schema:

• Added an information schema plugin to report all user variables, which creates the Information Schema USER_VARIABLES Table - MDEV-7331.

Variables:

• aria_recover has been renamed to aria_recover_options - MDEV-8542.
• The server version can now be faked to work around dated applications that require a particular version string - MDEV-7780
• slave_parallel_workers is now an alias for slave_parallel_threads.
• New status variables com_alter_user, com_multi and com_show_create_user.

EXPLAIN:

• EXPLAIN FORMAT=JSON now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution - MDEV-9652.
• EXPLAN FORMAT=JSON now shows sort_key field which shows the sort criteria used by filesort operation. (commit 2078392)

• 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

• 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.