Changes and Improvements in MariaDB 10.7

You are viewing an old version of this article. View the current version here.

MariaDB 10.7 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.7 is:
MariaDB 10.7.8 Stable (GA) Download Now

Upgrading
New Features & Improvements
Security Vulnerabilities Fixed in MariaDB 10.7
List of All MariaDB 10.7 Releases

MariaDB 10.7 is a previous short-term maintenance stable series. The first stable release was in February 2022, and it was maintained for one year.

Upgrading

See Upgrading Between Major MariaDB Versions and Upgrading from MariaDB 10.6 to MariaDB 10.7.

New Features & Improvements

UUID

New UUID data type (MDEV-4958)

JSON

JSON_EQUALS function to check for equality between JSON objects (MDEV-23143).
JSON_NORMALIZE function, which recursively sorts keys and removes spaces (MDEV-16375)

Natural Sort

NATURAL_SORT_KEY function (MDEV-4742).

Optimization

Improve simple multibyte collation performance on the ASCII range (MDEV-26572).

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)

mariadb-dump

Add option to dump system versioned table as of specified timestamp (MDEV-16355).

Convert Partitions

ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166), 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

Password Reuse

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)

Replication

Multi-source replication supports MySQL-style CHANNEL syntax (MDEV-26307)

InnoDB Bulk Insert

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

Diagnostics

GET DIAGNOSTICS supports a new condition property name ROW_NUMBER. In multi-row inserts it allows one to retrieve a number of a row that has caused the error (MDEV-10075, MDEV-26611)

Variables

The following deprecated variables have been removed :

Security Vulnerabilities Fixed in MariaDB 10.7

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

List of All MariaDB 10.7 Releases

Date	Release	Status	Release Notes	Changelog
6 Feb 2023	MariaDB 10.7.8	Stable (GA)	Release Notes	Changelog
7 Nov 2022	MariaDB 10.7.7	Stable (GA)	Release Notes	Changelog
19 Sep 2022	MariaDB 10.7.6	Stable (GA)	Release Notes	Changelog
15 Aug 2022	MariaDB 10.7.5	Stable (GA)	Release Notes	Changelog
20 May 2022	MariaDB 10.7.4	Stable (GA)	Release Notes	Changelog
12 Feb 2022	MariaDB 10.7.3	Stable (GA)	Release Notes	Changelog
9 Feb 2022	MariaDB 10.7.2	Stable (GA)	Release Notes	Changelog
8 Nov 2021	MariaDB 10.7.1	RC	Release Notes	Changelog
17 Sep 2021	MariaDB 10.7.0	Alpha	Release Notes

Comments

Comments loading...

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.