MariaDB 11.7.1 Release Notes

Download Release Notes Changelog Overview of 11.7

^{Alternate download from mariadb.org}

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

• Vectors are a feature that allow MariaDB Server to perform as a relational vector database. Previously available in the special Vector preview release, it has now been added to MariaDB Community Server 11.7.1 with various enhancements (MDEV-34939)
  • Data type VECTOR (MDEV-33410)
  • Conversion functions VEC_FromText and VEC_ToText (MDEV-32886)
  • Configuration options (MDEV-35244)
    • mhnsw_max_cache_size Upper limit for one MHNSW vector index cache
    • mhnsw_default_distance Default value for the DISTANCE vector index option
    • mhnsw_default_m Default value for the M vector index option
    • mhnsw_ef_search Defines the minimal number of result candidates to look for in the vector index for ORDER BY … LIMIT N queries.

Storage Engines

InnoDB

• Defaults change - the innodb_snapshot_isolation system variable now defaults to ON, previously was OFF (MDEV-35124)
• Fix attempt to read outside the bounds of the file: ./ibdata1 (MDEV-34453)
• Fix MariaDB crash with SIGILL because the OS does not support AVX512 (MDEV-34565)
• Fix deadlock caused by lock_rec_unlock_unmodified() (MDEV-34690)
• Fix duplicate key error in table 'mysql.innodb_table_stats' (MDEV-34207)
• Fix possible adaptive hash index corruption with ALTER TABLE...IMPORT TABLESPACE and FULLTEXT SEARCH (MDEV-35059)
• XA prepare now correctly releases unmodified records in non-blocking mode (MDEV-34466)
• Fix contention between secondary index UPDATE and purge due to large innodb_purge_batch_size (MDEV-34515)
• Fix redundant page lookups that hurt performance (MDEV-34791)
• Implement innodb_log_file_mmap on 64-bit systems for improving ib_logfile0 reads (MDEV-34062)

Spider

• Fix server crash when calling spider UDF after aria_encrypt_tables is enabled (MDEV-34682)
• SELECT MIN on Spider table no longer returns more rows than expected (MDEV-26345)
• Fix Spider group by handler wrong result on order by aggregate (MDEV-29546)

S3

• Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers (MDEV-34867)
  • A new option s3-provider has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3

Optimizer

• Fix crash caused by query containing constant having clause (MDEV-23983)
• Fix assertion with optimizer_join_limit_pref_ratio and 1-table select (MDEV-35072)

Data Definition - Alter Table

• Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE (MDEV-34938)
• Fix case where modification of the column incorrectly checked foreign key constraint (MDEV-34392)
• Fix incorrect NULL value handling for instantly dropped BLOB columns (MDEV-35122)

Galera

• Galera updated to 26.4.20
• Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table (MDEV-31173)
• TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table (MDEV-34836)
• Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera (MDEV-34647)
• Fix case where with wsrep_mode=REPLICATE_ARIA, only part of the mixed-engine transactions was replicated (MDEV-30653)
• Fix galera_ssl_reload failure with warning message (MDEV-32778)
• When InnoDB gets an assertion failure, WSREP layer is now handled gracefully (MDEV-32363)

Backup

• Recovery now correctly notes some log corruption (MDEV-34802)
• InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables (MDEV-34879)
• Can now selectively restore sequences using innodb tables from backup (MDEV-32350)

JSON

• JSON_TABLE now properly unquotes strings (MDEV-27412)
• JSON_TABLE default values now allows non-string literals (MDEV-25822)

General

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.7 for Windows 11 22H2
• mariadbd no longer hangs on startup when --init-file target does not exist (MDEV-34814)
• LOAD DATA INFILE with geometry data no longer fails (MDEV-34883)
• Fix heap-use-after-free in group_concat with compressed or GIS columns (MDEV-16699)
• Fix assertion `!is_cond()' failed in Item_bool_func::val_int / do_select (MDEV-35135)
• Trigger now works correctly with bulk update (MDEV-34718)
• Fix assertion failure in find_producing_item upon a query from a view (MDEV-35276)
• Add new setting, --quick-max-column-width to the mariadb client for use in --quick mode (MDEV-34704)

Changelog

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

Contributors

For a full list of contributors to MariaDB 11.7.1, see the MariaDB Foundation release announcement.