MariaDB 10.6.20 Release Notes

Download Release Notes Changelog Overview of 10.6

Release date: 1 Nov 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.20 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

• Fix attempt to read outside the bounds of the file: ./ibdata1 ()

• Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()

• Fix deadlock caused by lock_rec_unlock_unmodified() ()

• Fix duplicate key error in table 'mysql.innodb_table_stats' ()

• Fix server crash when calling after is enabled ()

• SELECT MIN on Spider table no longer returns more rows than expected ()

• Fix Spider group by handler wrong result on order by aggregate ()

• Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers ()

  • A new option has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3

  • New option , if true, SSL certificate verification for the S3 endpoint is disabled

Optimizer

• Fix crash caused by query containing constant having clause ()

• Fix assertion with optimizer_join_limit_pref_ratio and 1-table select ()

Data Definition - Alter Table

• Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE ()

• Modification of the column now correctly checks foreign key constraint ()

• Fix incorrect NULL value handling for instantly dropped BLOB columns ()

• Galera updated to 26.4.20

• Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table ()

• TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table ()

• Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera ()

Backup

• Recovery now correctly notes some log corruption ()

• InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables ()

• Can now selectively restore sequences using innodb tables from backup ()

JSON

• now properly unquotes strings ()

• default values now allows non-string literals ()

General

• As per the , this will be the last release of for SLES 12, and Windows 11 22H2

• no longer hangs on startup when --init-file target does not exist ()

• LOAD DATA INFILE with geometry data no longer fails ()

• Fix heap-use-after-free in group_concat with compressed or GIS columns ()

Changelog

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

Contributors

For a full list of contributors to , see the .