MariaDB 12.2.2 Release Notes
MariaDB 12.2.2 is a Stable (GA) release of MariaDB Community Server 12.2, released on 2026-02-12
Download Release Notes Changelog Overview of 12.2
Release date: 12 Feb 2026
MariaDB 12.2 is a rolling release. It is an evolution of MariaDB 12.1 with several entirely new features.
MariaDB 12.2.2 is a Stable (GA) release.
For an overview of MariaDB 12.2 see the MariaDB 12.2 Changes & Improvements page.
Thanks, and enjoy MariaDB!
New Features
Compatibility features
Implement Oracle TO_NUMBER function (MDEV-20022)
Implement Oracle TRUNC function (MDEV-20023)
Optimizer
Join optimizer is now able to infer that derived table with GROUP BY clause has distinct GROUP BY columns (MDEV-36321)
Optimizer hints
Optimizer hint: [NO_]ROWID_FILTER (MDEV-36089),
Optimizer hint: [NO_]INDEX_MERGE (MDEV-36125)
Optimizer hints: Implicit query block names (MDEV-37511)
Miscellaneous
Remove depth limit of 32 from JSON functions (MDEV-32854)
Implement INFORMATION_SCHEMA.PARAMETERS.PARAMETER_DEFAULT column (MDEV-37054)
Notable Items
Data Definition - Create Table
On an error in
CREATE TEMPORARY TABLE ... SELECT, InnoDB internally aborted a transaction, while the server thought the transaction still existed. This caused various inconsistencies in the binary log, disappearing savepoints, and more. The issue was fixed differently in different versions. In 10.11.16, 11.4.10, 11.8.6, and 12.2.2, the transaction is consistently and completely rolled back ifCREATE TEMPORARY TABLE ... SELECTfails with an error. In 12.3.1, there is no rollback at all. (MDEV-36787)
Plugin - Audit Log
Audit log plugin will now log events for MariaDB Cluster (Galera) replication applier operations with a generic user name:
<wsrep_applier>. Before this change the user name in audit logs has been empty (MDEV-35511)
Security
Fixes for the following security vulnerabilities:
Changelog
For a complete list of changes made in MariaDB 12.2.2, with links to detailed information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?

