DownloadRelease NotesChangelogOverview of 11.7
Alternate download from mariadb.org
Release date: 21 Nov 2024
Do not use non-stable (non-GA) releases in production!
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.
For an overview of MariaDB 11.7 see theWhat is MariaDB 11.7? page.
Thanks, and enjoy MariaDB!
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.
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)
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)
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
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)
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 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)
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_TABLE now properly unquotes strings (MDEV-27412)
JSON_TABLE default values now allows non-string literals (MDEV-25822)
New function for generating version 4 UUIDs UUIDv4 (MDEV-11339)
New function for generating version 7 UUIDs UUIDv7 (MDEV-32637)
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)
Fixes for the following security vulnerabilities:
CVE-`-```
For a complete list of changes made in MariaDB 11.7.1, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 11.7.1, see the MariaDB Foundation release announcement.
This page is licensed: CC BY-SA / Gnu FDL