MariaDB 10.7 Changes & Improvements

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

_{This page is licensed: CC BY-SA / Gnu FDL}