MariaDB 10.7.0 Release Notes

Download 10.7.0 Release Notes Changelog Overview of 10.7

Release date: 17 Sep 2021

MariaDB 10.7 is the current development series of MariaDB. It is an evolution of MariaDB 10.6 with several entirely new features.

MariaDB 10.7.0 is not a single release, but is instead a number of feature preview releases based on feature branches. Each should be considered as having a maturity of an Alpha release. Read more about feature preview releases here.

Thanks, and enjoy MariaDB!

Notable changes of this series of releases include:

Provider Plugins

• Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide compression capabilities to the server and storage engines (MDEV-12933, blog post).

SFORMAT

• SFORMAT function for arbitrary text formatting (MDEV-25015, blog post).

UUID

• New UUID data type (MDEV-4958, blog post)

Natural Sort

• NATURAL_SORT_KEY function (MDEV-4742, blog post).

JSON Histograms

• Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-21130, MDEV-26519, blog post). Note that this feature was not included in MariaDB 10.7.1.

Convert Partitions

• ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166, blog post), and
• ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... (MDEV-22165) as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP
• ALTER TABLE .. ADD PARTITION allows to omit the redundant PARTITION keyword (MDEV-26471)

Password Reuse

• The password_reuse_check plugin is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (MDEV-9245, blog post).

InnoDB Bulk Insert

• In bulk insert, pre-sort and build indexes one page at a time (MDEV-24621)

Misc. Features

• JSON_EQUALS function to check for equality between JSON objects (MDEV-23143).
• JSON_NORMALIZE function, which recursively sorts keys and removes spaces (MDEV-16375)
• Improve simple multibyte collation performance on the ASCII range (MDEV-26572).
• Add option to dump system versioned table as of specified timestamp (MDEV-16355).
• Multi-source replication supports MySQL-style CHANNEL syntax (MDEV-26307)
• GET DIAGNOSTICS supports a new condition property name ERROR_INDEX. In multi-row inserts it allows to retrieve a number of a row that has caused the error (MDEV-10075)
• wsrep_replicate_myisam and wsrep_strict_ddl deprecated system variables were removed (MDEV-24947, MDEV-24843)