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

Changes and Improvements in MariaDB 12.0

Contents

  1. Upgrading
  2. New Features
    1. Security
    2. Data types
    3. Stored Routines
    4. Server
    5. Optimizer
    6. GIS
    7. Trigger
    8. Replication
    9. Galera
    10. Audit Plugin
    11. Configuration
    12. mariadb Client
  3. Security Vulnerabilities Fixed in MariaDB 12.0
  4. List of All MariaDB 12.0 Releases

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.

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)

List of All MariaDB 12.0 Releases

DateReleaseStatusRelease NotesChangelog
UnreleasedAlpha
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.