# MariaDB 12.2 Changes & Improvements

{% hint style="info" %}

<p align="center">The most recent release of MariaDB 12.2 is:</p>

<h4 align="center"><strong>MariaDB 12.2.2</strong> <a href="https://mariadb.com/downloads/" class="button primary">Download Now</a></h4>

<p align="center"><a href="https://downloads.mariadb.org/mariadb/12.2.2/"><sub><em>Alternate download from mariadb.org</em></sub></a></p>
{% endhint %}

MariaDB 12.2 is a [rolling release](https://mariadb.com/docs/release-notes/community-server/about/release-model). It is an evolution of [MariaDB 12.1](https://mariadb.com/docs/release-notes/community-server/old-releases/12.1/changes-and-improvements-in-mariadb-12.1) with several entirely new features.

## New Features

### Compatibility features <a href="#compatibility-features" id="compatibility-features"></a>

* Implement Oracle [TO\_NUMBER](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/numeric-functions/to_number) function ([MDEV-20022](https://jira.mariadb.org/browse/MDEV-20022))
* Implement Oracle [TRUNC](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/date-time-functions/trunc) function ([MDEV-20023](https://jira.mariadb.org/browse/MDEV-20023))

### Optimizer <a href="#optimizer" id="optimizer"></a>

* Join optimizer is now able to infer that derived table with GROUP BY clause has distinct GROUP BY columns ([MDEV-36321](https://jira.mariadb.org/browse/MDEV-36321))

#### Optimizer hints <a href="#optimizer-hints" id="optimizer-hints"></a>

* [Optimizer hint](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/optimizer-hints): \[NO\_]ROWID\_FILTER ([MDEV-36089](https://jira.mariadb.org/browse/MDEV-36089)),
* [Optimizer hint](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/optimizer-hints): \[NO\_]INDEX\_MERGE ([MDEV-36125](https://jira.mariadb.org/browse/MDEV-36125))
* [Optimizer hints](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/optimizer-hints): Implicit query block names ([MDEV-37511](https://jira.mariadb.org/browse/MDEV-37511))

### Miscellaneous <a href="#miscellaneous" id="miscellaneous"></a>

* Remove depth limit of 32 from JSON functions ([MDEV-32854](https://jira.mariadb.org/browse/MDEV-32854))
* Add [INFORMATION\_SCHEMA.TRIGGERED\_UPDATE\_COLUMNS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-triggered_update_columns) ([MDEV-36996](https://jira.mariadb.org/browse/MDEV-36996))
* Implement [INFORMATION\_SCHEMA.PARAMETERS](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/information-schema/information-schema-tables/information-schema-parameters-table).PARAMETER\_DEFAULT column ([MDEV-37054](https://jira.mariadb.org/browse/MDEV-37054))

### Preview release only <a href="#miscellaneous" id="miscellaneous"></a>

These features needed further testing and will be implemented in a future series.

* Implement Global temporary tables ([MDEV-35915](https://jira.mariadb.org/browse/MDEV-35915)) (preview release only)
* Improved support of [replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication) between tables of different structure ([MDEV-36290](https://jira.mariadb.org/browse/MDEV-36290)) (preview release only)

## List of All MariaDB 12.2 Releases

| Date        | Release              | Status      | Release Notes                                                                        | Changelog                                                                                   |
| ----------- | -------------------- | ----------- | ------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------- |
| 12 Feb 2026 | 12.2.2               | Stable (GA) | [Release Notes](https://mariadb.com/docs/release-notes/community-server/12.2/12.2.2) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/12.2/12.2.2) |
| 21 Nov 2025 | 12.2.1               | RC          | [Release Notes](https://mariadb.com/docs/release-notes/community-server/12.2/12.2.1) | [Changelog](https://mariadb.com/docs/release-notes/community-server/changelogs/12.2/12.2.1) |
| 23 Sep 2025 | MariaDB 12.2 Preview | Preview     |                                                                                      |                                                                                             |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>