MariaDB 11.7.1 Release Notes

Download Release Notes Changelog Overview of 11.7

Release date: 21 Nov 2024

MariaDB 11.7 is a rolling release. It is an evolution of MariaDB 11.6 with several entirely new features.

MariaDB 11.7.1 is a Release Candidate (RC) release.

Thanks, and enjoy MariaDB!

Notable Items

Vectors

• are a feature that allow MariaDB Server to perform as a relational vector database. Previously available in the special , it has now been added to MariaDB Community Server 11.7.1 with various enhancements ()

  • Data type VECTOR ()

  • Conversion functions VEC_FromText and VEC_ToText ()

Storage Engines

InnoDB

• Defaults change - the system variable now defaults to ON, previously was OFF ()

• 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 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

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

• Fix case where modification of the column incorrectly checked foreign key constraint ()

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

Galera

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

UUID

• New function for generating version 4 UUIDs ()

• New function for generating version 7 UUIDs ()

General

• As per the , this will be the last release of for 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 made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .