All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 12.0.1 Release Notes

Download Release Notes Changelog Overview of 12.0

Alternate download from mariadb.org

Release date: 5 Jun 2025

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 Changes and Improvements in MariaDB 12.0 page.

Thanks, and enjoy MariaDB!

Notable Items

Security

  • Support for passphrase protected keys ()

  • New SET SESSION AUTHORIZATION ()

  • Implement SHA2 support for file_key_management.so plugin (TDE) ()

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. ()

Stored Routines

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

Server

  • TO_CHAR FM format not recognized in SQL_MODE=Oracle ()

  • Support mariadb-check and CHECK TABLE with SEQUENCE ()

Optimizer

  • find_order_in_list mismatch when order item needs fixing() ()

  • If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query ()

  • Add support for optimizer hints ()

    • QB_NAME()

GIS

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

  • ()

  • ()

  • ()

  • ()

Trigger

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

Replication

  • Server now displays if it was started with option ()

Galera

  • Skip FK checks in Galera during applying in IST ()

Audit Plugin

  • Log HOST:PORT of incoming connection instead of just the host ()

  • Add tls_version field for connection audit plugins ()

Configuration

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

Clients and Scripts

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

Changelog

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

Contributors

For a full list of contributors to MariaDB 12.0.1, see the .


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)

  • (MDEV-34159)

  • (MDEV-34160)

  • (MDEV-34277)

  • (MDEV-34276)

  • (MDEV-34278)

  • MDEV-14091
    MDEV-20299
    MDEV-34712
    MDEV-36322
    MDEV-20034
    MDEV-36216
    MDEV-22491
    MDEV-36607
    MDEV-36592
    MDEV-35504
    MDEV-34137
    MDEV-34138
    MDEV-34141
    MDEV-34158
    MDEV-10164
    MDEV-27669
    MDEV-34822
    MDEV-1282
    MDEV-33834
    MDEV-21375
    MDEV-23818
    changelog
    MariaDB Foundation release announcement

    The most recent release of MariaDB 12.0 is:

    MariaDB 12.0.2 Stable (GA) Download Now

    Alternate download from mariadb.org

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

    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 page.

    Distributions which Include MariaDB
    ST_Validate
    MBRCoveredBy
    ST_Simplify
    ST_GeoHash
    skip-slave-start
    ST_LatFromGeoHash
    ST_LongFromGeoHash
    ST_PointFromGeoHash
    ST_IsValid
    ST_Collect

    This page is licensed: CC BY-SA / Gnu FDL