> 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/11.2/11.2.0.md). # MariaDB 11.2.0 Release Notes The most recent release of [MariaDB 11.2](/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md) is:[**MariaDB 11.2.6**](/docs/release-notes/community-server/old-releases/11.2/11.2.6.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/11.2.6/)[*Alternate download from mariadb.org*](https://downloads.mariadb.org/mariadb/11.2.6/) [Download 11.2.0](https://downloads.mariadb.org/mariadb/11.2.0) | [Release Notes](/docs/release-notes/community-server/old-releases/11.2/11.2.0.md) | [Changelog](/docs/release-notes/community-server/changelogs/11.2.md) | [Overview of 11.2](/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md) **Release date:** 20 Jun 2023 **Do not use *****alpha***** releases in production!** [MariaDB 11.2](/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md) is a short-term development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of [MariaDB 11.1](/docs/release-notes/community-server/old-releases/11.1/what-is-mariadb-111.md) with several entirely new features. [MariaDB 11.2.0](/docs/release-notes/community-server/old-releases/11.2/11.2.0.md) is a single preview release. Features are to be considered preview, and none are guaranteed to make it into [MariaDB 11.2](/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md). The preview is available as a container **quay.io/mariadb-foundation/mariadb-devel:11.2-preview**. **For an overview of** [**MariaDB 11.2**](/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md) **see the**[**What is MariaDB 11.2?**](/docs/release-notes/community-server/old-releases/11.2/what-is-mariadb-112.md) **page.** Thanks, and enjoy MariaDB! ## InnoDB * The [InnoDB system tablespace](/docs/server/server-usage/storage-engines/innodb/innodb-tablespaces/innodb-system-tablespaces.md) is now shrunk by reclaiming unused space at startup ([MDEV-14795](https://jira.mariadb.org/browse/MDEV-14795)) ## JSON * [JSON\_TABLE](/docs/server/reference/sql-functions/special-functions/json-functions/json_table.md) now allows retrieval of the key when iterating on JSON objects ([MDEV-30145](https://jira.mariadb.org/browse/MDEV-30145)) * New functions [JSON\_OBJECT\_FILTER\_KEYS](/docs/server/reference/sql-functions/special-functions/json-functions/json_object_filter_keys.md), [JSON\_OBJECT\_TO\_ARRAY](/docs/server/reference/sql-functions/special-functions/json-functions/json_object_to_array.md) and [JSON\_ARRAY\_INTERSECT](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_intersect.md) to check for JSON intersection ([MDEV-26182](https://jira.mariadb.org/browse/MDEV-26182)) * [JSON\_KEY\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/json_key_value.md) extracts key/value pairs from a JSON object ([MDEV-30145](https://jira.mariadb.org/browse/MDEV-30145)) ## Miscellaneous * All binlog\* variables are now visible as system variables, specifically [binlog\_do\_db](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_do_db), [binlog\_ignore\_db](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_ignore_db), [binlog\_row\_event\_max\_size](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#binlog_row_event_max_size) ([MDEV-30188](https://jira.mariadb.org/browse/MDEV-30188)) * [ALTER TABLE IMPORT](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) enhancement ([MDEV-26137](https://jira.mariadb.org/browse/MDEV-26137)) * Temporary tables are now displayed in the [Information Schema TABLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-tables-table.md), [SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md) and [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md) ([MDEV-12459](https://jira.mariadb.org/browse/MDEV-12459)) * [Stored programs](/docs/server/server-usage/stored-routines.md): validation of stored program statements ([MDEV-5816](https://jira.mariadb.org/browse/MDEV-5816)) * Remove the deprecated [old\_alter\_table](/docs/server/server-management/variables-and-modes/server-system-variables.md#old_alter_table) variable ([MDEV-30905](https://jira.mariadb.org/browse/MDEV-30905)) * Extend [AES\_ENCRYPT()](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/aes_encrypt.md) and [AES\_DECRYPT()](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/aes_decrypt.md) to support an initialization vector and algorithm ([MDEV-9069](https://jira.mariadb.org/browse/MDEV-9069)) {% 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 %} *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formid="4316" formId="4316" %}