MariaDB 11.8.1 Release Notes

Download Release Notes Changelog Overview of 11.8

^{Alternate download from mariadb.org}

Release date: 13 Feb 2025

MariaDB 11.8 is a current long-term development series of MariaDB. It is an evolution of MariaDB 11.7 with several entirely new features.

MariaDB 11.8.1 is a Release Candidate (RC) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182)

Optimizer

• Fix possibly wrong result using a degenerated subquery (SELECT <expr>) with window function (MDEV-35869)
• Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition (MDEV-35910)
• Support ORDER BY and LIMIT for multi-table DELETE, index hints for single-table DELETE. (MDEV-30469)
• Optimizer can now use indexed virtual columns in WHERE/ON clauses for improved query performance. (MDEV-35616)
• Make SUBSTR(col, 1, n) = const_str sargable (MDEV-34911)

PL/SQL

• It is now possible to define default values (or expressions) for parameters to stored procedures, stored functions and UDFs (MDEV-10862)
• New DECLARE TYPE type_name IS RECORD (..) with scalar members in stored routines (MDEV-34317)
• It was not possible to use a package body variable as a fetch target, instead error "Undeclared variable" was returned. (MDEV-36047)

Triggers

• Fix trigger created with "CREATE TRIGGER `table1_after_insert` AFTER INSERT" which is adding rows to another table using "FOR EACH ROW insert into table2(`id`, `name`) values (NEW.`id`, NEW.`name`);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table (MDEV-34958)
• A Trigger definition can now include column names for specifying the columns for which a trigger should be called (MDEV-34551)
• Triggers can now use SIGNAL SQLSTATE '02TRG' to skip row operations (insert, update, delete) in BEFORE triggers, affecting data modification. (MDEV-34724)

Data types

• Fix possible hang or crash where zero offset applied to null pointer (MDEV-35864)
• Comparison of UUID v1 and V6 could return incorrect results (MDEV-35468)

Character Sets

• Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer (MDEV-35549)
• Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump (MDEV-29968)
• OS character sets "utf8" and "utf-8" now map to MariaDB character set "utf8mb4" for full UTF-8 support. (MDEV-22217)

Stored routines

• Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. (MDEV-24935)

Scripts & Clients

• When using mariadb-import with --innodb-optimize-keys, secondary index creation is delayed until after data load, potentially improving load speed. (MDEV-34740)

Changelog

For a complete list of changes made in MariaDB 11.8.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.