Changes and Improvements in MariaDB 12.0

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

New Features

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.

• ST_Validate (MDEV-34137)

• MBRCoveredBy (MDEV-34138)

• ST_Simplify (MDEV-34141)

• ST_GeoHash (MDEV-34158)

• ST_LatFromGeoHash (MDEV-34159)

• ST_LongFromGeoHash (MDEV-34160)

• ST_PointFromGeoHash (MDEV-34277)

• ST_IsValid (MDEV-34276)

• ST_Collect (MDEV-34278)

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)

mariadb Client

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

Security Vulnerabilities Fixed in MariaDB 12.0

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

List of All MariaDB 12.0 Releases

Date	Release	Status	Release Notes	Changelog
5 Jun 2025	MariaDB 12.0.1	RC	Release Notes	Changelog