MariaDB 13.0.2 Release Notes
MariaDB 13.0.2 is a Stable (GA) release of MariaDB Community Server 13.0, released on 2026-09-15
Alternate download from mariadb.org
Release date: 15 Sep 2026
MariaDB 13.0 is a rolling release. It is an evolution of MariaDB 12.3 with several entirely new features.
MariaDB 13.0.2 is a Stable (GA) release.
For an overview of MariaDB 13.0 see the MariaDB 13.0 Changes & Improvements page.
Thanks, and enjoy MariaDB!
New Features
Add support for
TYPE .. IS REF CURSOR(MDEV-10152)In 13.0,
REF CURSORcan be declared inside package routines and in aPACKAGE BODY, and used as a package routine local variable, package routine parameter, or package functionRETURNtype. It cannot yet be used as a parameter orRETURNtype for global (non-package) routines.
Support
RECORDin routine parameters and functionRETURNclause (MDEV-38768)Same scope as
REF CURSORabove: usable as a package routine parameter or package functionRETURNtype, not yet as a parameter orRETURNtype for global (non-package) routines.
Add
init_rpl_roletoSHOW VARIABLESoutput (MDEV-38202)The replication role set via the
--init-rpl-rolestartup option can now be queried withSHOW VARIABLES LIKE 'init_rpl_role'orSELECT @@init_rpl_role, instead of only being visible in the server's configuration file.
One can specify timestamp format for the audit plugin log (MDEV-18386)
Atomic
CREATE OR REPLACE TABLE(MDEV-25292)Implement
UPDATE ... RETURNINGfor single-table updates (MDEV-5092)Combined with
OLD_VALUE(), an application can read back both the pre- and post-update values of changed columns in one round trip, without a separateSELECT. Only single-tableUPDATEsupportsRETURNING; multi-tableUPDATEdoes not yet.
INFORMATION_SCHEMA.SYSTEM_VARIABLESshows if a variable is deprecated (MDEV-35369)Adds
IS_DEPRECATEDandDEPRECATED_REPLACEMENTcolumns, so tooling can query deprecation status directly instead of relying on release notes.
INFORMATION_SCHEMA.STATISTICSandINFORMATION_SCHEMA.COLUMNSshows engine specific create options (MDEV-36444)Optimizer Trace includes used optimizer statistics (MDEV-36511)
New
innodb_log_archivevariable makes InnoDB preserve the write-ahead log in a continuous sequence of files instead of overwriting a ring buffer, enabling point-in-time recovery and incremental backups (MDEV-37949)mariadb-backupdoes not yet support theinnodb_log_archive=ONlog format, and fails if run against a server running with it enabled. See InnoDB Log Archiving and Point-in-Time Recovery for the manual procedure in the meantime.
New
QB_NAME()optimizer hint (MDEV-38045)Every view, CTE, and derived table now automatically gets an implicit query block name based on its own alias, so hints can target objects inside them without adding an explicit
QB_NAME()hint first.A new locator form of
QB_NAME(),QB_NAME(name, query_block_path), lets a hint specify a path to a query block nested inside a view, CTE, or derived table that isn't reachable by its implicit or explicit name alone.
Reversed executable comments (MDEV-7381)
Notable Items
CHANGE MASTERnow resetsMaster_Server_IdinSHOW SLAVES STATUS(MDEV-15327)Faster unique indexes over
CHARcolumns in MEMORY tables (incl. temporary tables) (MDEV-21543)PERFORMANCE_SCHEMAnow usesXXH3_128hash for digest. Looks like MD5, but much faster and no problems in FIPS mode. (MDEV-31669)binlog_row_event_max_sizedefault value was increased to 64k (MDEV-37608)default_master_connectioncan now be set on global level (MDEV-9247)
Changelog
For a complete list of changes made in MariaDB 13.0.2, with links to detailed information on each push, see the changelog.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?

