Changes and Improvements in MariaDB 10.7

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

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

• For a list of all new variables, see System Variables Added in MariaDB 10.7 and Status Variables Added in MariaDB 10.7.

The following deprecated variables have been removed :

• wsrep_replicate_myisam (MDEV-24947)

• wsrep_strict_ddl (MDEV-24843)

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.

• CVE-2023-5157: MariaDB 10.7.5

• CVE-2022-38791: MariaDB 10.7.5

• CVE-2022-32091: MariaDB 10.7.5

• CVE-2022-32089: MariaDB 10.7.5

• CVE-2022-32088: MariaDB 10.7.4

• CVE-2022-32087: MariaDB 10.7.4

• CVE-2022-32086: MariaDB 10.7.4

• CVE-2022-32085: MariaDB 10.7.4

• CVE-2022-32084: MariaDB 10.7.5

• CVE-2022-32083: MariaDB 10.7.4

• CVE-2022-32082: MariaDB 10.7.5

• CVE-2022-32081: MariaDB 10.7.5

• CVE-2022-27458: MariaDB 10.7.4

• CVE-2022-27457: MariaDB 10.7.4

• CVE-2022-27456: MariaDB 10.7.4

• CVE-2022-27455: MariaDB 10.7.4

• CVE-2022-27452: MariaDB 10.7.4

• CVE-2022-27451: MariaDB 10.7.4

• CVE-2022-27449: MariaDB 10.7.4

• CVE-2022-27448: MariaDB 10.7.4

• CVE-2022-27447: MariaDB 10.7.4

• CVE-2022-27446: MariaDB 10.7.4

• CVE-2022-27445: MariaDB 10.7.4

• CVE-2022-27444: MariaDB 10.7.4

• CVE-2022-27387: MariaDB 10.7.4

• CVE-2022-27386: MariaDB 10.7.4

• CVE-2022-27384: MariaDB 10.7.4

• CVE-2022-27383: MariaDB 10.7.4

• CVE-2022-27382: MariaDB 10.7.4

• CVE-2022-27381: MariaDB 10.7.4

• CVE-2022-27380: MariaDB 10.7.4

• CVE-2022-27379: MariaDB 10.7.4

• CVE-2022-27378: MariaDB 10.7.4

• CVE-2022-27377: MariaDB 10.7.4

• CVE-2022-27376: MariaDB 10.7.4

• CVE-2022-24052: MariaDB 10.7.2

• CVE-2022-24051: MariaDB 10.7.2

• CVE-2022-24050: MariaDB 10.7.2

• CVE-2022-24048: MariaDB 10.7.2

• CVE-2022-21595: MariaDB 10.7.2

• CVE-2022-0778: MariaDB 10.7.2

• CVE-2021-46669: MariaDB 10.7.4

• CVE-2021-46668: MariaDB 10.7.3

• CVE-2021-46665: MariaDB 10.7.3

• CVE-2021-46664: MariaDB 10.7.3

• CVE-2021-46663: MariaDB 10.7.3

• CVE-2021-46661: MariaDB 10.7.3

• CVE-2021-46659: MariaDB 10.7.2

• CVE-2018-25032: MariaDB 10.7.5

List of All MariaDB 10.7 Releases

Date	Release	Status	Release Notes	Changelog
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