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