The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2025-06-06. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 12.0.1 Release Notes

Download Release Notes Changelog Overview of 12.0

Release date: 5 Jun 2025

Do not use non-stable (non-GA) releases in production!

MariaDB 12.0 is a rolling release. It is an evolution of MariaDB 11.8 with several entirely new features.

MariaDB 12.0.1 is a Release Candidate (RC) release.

For an overview of MariaDB 12.0 see the What is MariaDB 12.0? page.

Thanks, and enjoy MariaDB!

Notable Items

Security

  • Support for passphrase protected keys (MDEV-14091)
  • New SET SESSION AUTHORIZATION (MDEV-20299)
  • Implement SHA2 support for file_key_management.so plugin (TDE) (MDEV-34712)

Data types

  • Comparison ROW(stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. (MDEV-36322)

Stored Routines

  • Add support for the pre-defined weak SYS_REFCURSOR (MDEV-20034)

Server

  • TO_CHAR FM format not recognized in SQL_MODE=Oracle (MDEV-36216)
  • Support mariadb-check and CHECK TABLE with SEQUENCE (MDEV-22491)

Optimizer

  • find_order_in_list mismatch when order item needs fixing() (MDEV-36607)
  • If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query (MDEV-36592)
  • Add support for optimizer hints (MDEV-35504)
    • QB_NAME()
    • NO_RANGE_OPTIMIZATION()
    • NO_ICP()
    • MRR(), NO_MRR()
    • BKA(), NO_BKA()
    • BNL(), NO_BNL()
  • Add support for subquery optimizer hints (MDEV-34888)
    • SEMIJOIN()
    • SUBQUERY()
  • Add support for join order hints (MDEV-34870)
    • JOIN_FIXED_ORDER similar to existing STRAIGHT_JOIN hint
    • JOIN_ORDER to apply the specified table order
    • JOIN_PREFIX to hint what tables should be first in the join
    • JOIN_SUFFIX to hint what tables should be last in the join
  • Add support for the MAX_EXECUTION_TIME hint (MDEV-34860)

GIS

New GIS functions. These functions improve compatibility with MySQL 8.

Trigger

  • Add support for TRIGGERS that fire on multiple events (MDEV-10164)

Replication

  • Add option to check whether a server was started with skip-slave-start option (MDEV-27669)

Galera

  • Skip FK checks in Galera during applying in IST (MDEV-34822)

Audit Plugin

  • Log HOST:PORT of incoming connection instead of just the host (MDEV-1282)
  • Add tls_version field for connection audit plugins (MDEV-33834)

Configuration

  • Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX (MDEV-21375)

Clients and Scripts

  • Can set an alternative directory path for searching scripts invoked via the source command, with the --script-dir mariadb client option (MDEV-23818)

Changelog

For a complete list of changes made in MariaDB 12.0.1, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 11.8.1, see the MariaDB Foundation release announcement.

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.

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.