> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/12.2/12.2.1.md).

# MariaDB 12.2.1 Release Notes

{% 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 %}

<a href="https://downloads.mariadb.org/mariadb/12.2.1/" class="button primary">Download</a> <a href="/pages/GuMCfCTK7se3pXFq1RHe" class="button secondary">Release Notes</a> <a href="/pages/s1IWLxsQ2D3ogNGVCvpo" class="button secondary">Changelog</a> <a href="/pages/BbDGB5jIV2M0UGJV8iFr" class="button secondary">Overview of 12.2</a>

**Release date:** 21 Nov 2025

{% hint style="danger" %} <mark style="color:red;">**Do not use non-stable (non-GA) releases in production!**</mark>
{% endhint %}

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

MariaDB 12.2.1 is a [***Release Candidate (RC)***](/docs/release-notes/community-server/about/release-criteria.md) release.

{% hint style="success" %}
**For an overview of MariaDB 12.2 see the** [**MariaDB 12.2 Changes & Improvements**](/docs/release-notes/community-server/old-releases/12.2/mariadb-12.2-changes-and-improvements.md) **page.**
{% endhint %}

Thanks, and enjoy MariaDB!

## New Features

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

* [Optimizer hint](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md): \[NO\_]ROWID\_FILTER ([MDEV-36089](https://jira.mariadb.org/browse/MDEV-36089)),
* [Optimizer hint](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md): \[NO\_]INDEX\_MERGE ([MDEV-36125](https://jira.mariadb.org/browse/MDEV-36125))
* [Optimizer hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md): Implicit query block names ([MDEV-37511](https://jira.mariadb.org/browse/MDEV-37511))
* Implement Oracle [TO\_NUMBER](/docs/server/reference/sql-functions/numeric-functions/to_number.md) function ([MDEV-20022](https://jira.mariadb.org/browse/MDEV-20022))
* Implement Oracle [TRUNC](/docs/server/reference/sql-functions/date-time-functions/trunc.md) function ([MDEV-20023](https://jira.mariadb.org/browse/MDEV-20023))

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

* Remove depth limit of 32 from JSON functions ([MDEV-32854](https://jira.mariadb.org/browse/MDEV-32854))
* Indexes on derived tables with GROUP BY produce wrong out\_rows estimates ([MDEV-36321](https://jira.mariadb.org/browse/MDEV-36321))
* Add [INFORMATION\_SCHEMA.TRIGGERED\_UPDATE\_COLUMNS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-triggered_update_columns.md) ([MDEV-36996](https://jira.mariadb.org/browse/MDEV-36996))
* Implement [INFORMATION\_SCHEMA.PARAMETERS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-parameters-table.md).PARAMETER\_DEFAULT column ([MDEV-37054](https://jira.mariadb.org/browse/MDEV-37054))

## Changelog

For a complete list of changes made in MariaDB 12.2.1, with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/12.2/12.2.1.md).

***

{% hint style="info" %}
Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) 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](/docs/general-resources/distributions-including-mariadb.md) page.
{% endhint %}

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

{% @marketo/form formid="4316" formId="4316" %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/release-notes/community-server/old-releases/12.2/12.2.1.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
