MariaDB 11.7.1 Changelog

DownloadRelease NotesChangelogOverview of 11.7

Alternate download from mariadb.org

Release date: 21 Nov 2024

For the highlights of this release, see the release notes.

The revision number links will take you to the revision's page on GitHub. On GitHub you can view more details of the revision and view diffs of the code modified in that revision.

• Changes from 11.7.0 are also included in this changelog

• Includes all fixes from

• 2024-11-10 15:49:31 +0100

  • bump the VERSION

• 2024-11-10 15:45:16 +0100

  • fix the test for --embedded

• Merge 2024-11-09 19:01:12 +0100 - Merge branch '11.6' into 11.7

• 2024-11-07 06:15:18 -0800

  • InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON upon LOAD DATA REPLACE with unique blob

• 2024-11-07 06:07:54 -0800

  • cleanup: main.loaddata_autocom_innodb

• 2024-11-04 04:25:31 -0800

  • ER_LOCK_DEADLOCK not detected upon DML on table with vector key, server crashes

• 2024-11-01 13:31:48 +0100

  • NO_KEY_OPTIONS SQL mode has no effect on engine key options

• 2024-10-31 22:38:06 +0100

  • Server crashes in FVectorNode::gref_len with insufficient mhnsw_max_cache_size

• 2024-10-31 08:37:23 +0100

  • ER_KEY_NOT_FOUND upon INSERT into InnoDB table with vector key under READ COMMITTED

• 2024-10-30 21:50:29 +0100

  • DESC does not work in ORDER BY with vector key

• 2024-10-30 10:03:18 +0100

  • relax the XA recovery error

• 2024-10-29 17:53:38 +0100

  • Vector-related system variables could use better names

• 2024-10-29 09:44:24 +0100

  • Server crashes in _ma_reset_history upon altering on Aria table with vector key under lock

• 2024-10-26 13:38:45 +0200

  • mariadb-backup does not work with MyISAM tables with vector keys

• 2024-10-25 21:38:08 +0200

  • Vector search skips a row in the table

• 2024-09-10 16:55:02 +0400

  • DDL recovery for high-level indexes

• 2024-10-23 23:04:56 +0400

  • Assertion fails in trx_t::check_bulk_buffer upon CREATE.. SELECT with vector key

• 2024-10-25 15:58:06 +0200

  • post-fix

• 2024-10-10 16:49:39 +0400

  • Aria crashes with high-level (vector) indexes

• 2024-10-24 14:32:35 +0200

  • SHOW CREATE TABLE produces unusable statement for vector fields with constant default value

• 2024-10-23 20:56:12 +0200

  • ASAN errors upon reading from joined temptable views with vector type

• 2024-10-23 20:08:57 +0200

  • REPAIR does not fix MyISAM table with vector key after crash recovery

• 2024-10-23 17:23:30 +0200

  • Unexpected ER_DUP_KEY after OPTIMIZE on MyISAM table with vector key

• 2024-10-23 17:07:17 +0200

  • Assertion `!item->null_value' failed upon VEC_TOTEXT call

• 2024-10-23 14:25:11 +0200

  • Assertion `(mem_root->flags & 4) == 0' failed in safe_lexcstrdup_root

• 2024-10-20 16:47:20 +0200

  • ASAN errors in Item_func_vec_fromtext::val_str upon VEC_FROMTEXT with an invalid argument

• 2024-10-20 12:38:09 +0200

  • Server crash in online alter upon concurrent ALTER and DML on table with vector field

• 2024-10-20 00:15:27 +0200

  • Vector type cannot store values which VEC_FromText produces and VEC_ToText accepts

• 2024-10-19 21:08:11 +0200

  • Server crashes in Item_func_vec_fromtext::val_str upon query from empty table

• 2024-10-19 20:08:28 +0200

  • ASAN errors or assertion failures in row_sel_convert_mysql_key_to_innobase upon query from table with usual key on vector field

• 2024-10-19 20:05:17 +0200

  • Assertion `tab->join->order' fails upon vector search with DISTINCT #2

• 2024-10-19 20:33:57 +0200

  • non-BNL join fails on assertion

• 2024-10-20 12:53:27 +0200

  • Server crash or assertion failure upon query with high value of mhnsw_min_limit

• 2024-10-19 14:19:57 +0200

  • mysqlbinlog --verbose fails on row events with vector type

• 2024-10-17 18:39:21 +0200

  • Unexpected ER_TRUNCATED_WRONG_VALUE_FOR_FIELD, diagnostics area assertion failures upon EITS collection with vector type

• 2024-10-16 17:41:56 +0200

  • RBR does not work with vector type, ER_SLAVE_CONVERSION_FAILED

• 2024-10-18 17:31:28 +0200

  • Assertion failure in Create_tmp_table::finalize upon DISTINCT with vector type

• 2024-10-17 15:27:45 +0200

  • ASAN errors in Field_vector::store with optimizer_trace enabled

• 2024-10-17 09:37:11 +0200

  • Assertion failure in Field_vector::store upon INSERT IGNORE with a wrong data

• 2024-10-29 12:11:41 +0100

  • crash in online_alter_end_trans with XA over vector indexes

• 2024-10-16 13:10:28 +0200

  • Assertion `tab->join->select_limit < (~ (ha_rows) 0)' fails upon forcing vector key

• 2024-10-15 23:00:44 +0200

  • cleanup: remove String::append_float

• 2024-10-15 19:05:18 +0200

  • Vec_ToText was underestimating max_length of the result

• 2024-10-15 18:58:50 +0200

  • Assertion `res->length() > 0 && res->length() % 4 == 0' fails upon increasing length of vector column

• 2024-10-15 18:00:01 +0200

  • Column containing non-vector tables can be modified to VECTOR type without warnings

• 2024-10-15 17:36:08 +0200

  • Inconsistent NULL handling in vector type

• 2024-10-15 14:48:44 +0200

  • Server crashes in Field_vector::report_wrong_value upon statistic collection

• 2024-10-13 14:15:25 +0200

  • VECTOR data type

• 2024-10-09 09:25:12 +0200

  • Assertion `tab->join->order' fails upon vector search with DISTINCT

• 2024-10-08 22:57:10 +0200

  • Invalid (old?) table or database name upon DDL on table with vector key and unique key

• 2024-10-08 14:56:35 +0200

  • Server crash, hang or ASAN errors in mysql_create_frm_image upon using non-default table options and system variables

• 2024-10-06 20:09:08 +0200

  • make MyISAM and Aria report correct reflength to the server

• 2024-10-06 11:55:54 +0200

  • Server crash or ASAN errors in mhnsw_insert

• 2024-10-04 14:31:49 +0200

  • mysqldump and mariadb-backup tests of vector indexes

• 2024-10-02 20:33:42 +0200

  • XA PREPARE "not supported by the engine" from storage engine mhnsw, memory leak

• 2024-10-02 17:34:51 +0200

  • Assertion failure upon DML on table with vector under lock

• 2024-10-01 16:01:38 +0200

  • ASAN errors in TABLE_SHARE::lock_share upon committing transaction after FLUSH on table with vector key

• 2024-09-30 22:59:47 +0200

  • Behavior for RTREE indexes changed, assertion fails

• 2024-09-30 22:17:47 +0200

  • Vector indexes are allowed for MERGE tables, but do not

• 2024-09-30 19:22:30 +0200

  • ALTER on a table with vector index attempts to bypass unsupported locking limitation, server crashes in THD::free_tmp_table_share

• 2024-09-30 19:12:31 +0200

  • Unsuitable error upon an attempt to create MEMORY table with vector key

• 2024-09-26 19:33:13 +0200

  • streaming mode for mhnsw search

• 2024-09-27 21:10:53 +0200

  • cleanup: simplify search_layer() usage, remove std::swap()

• 2024-09-26 19:52:12 +0200

  • rename MHNSW_Context->MHNSW_Share

• 2024-09-29 15:46:28 +0200

  • ASAN errors in Lex_ident<Compare_ident_ci>::is_valid_ident upon DDL on table with vector index

• 2024-09-29 14:09:26 +0200

  • LeakSanitizer errors in my_malloc / safe_mutex_lazy_init_deadlock_detection / MHNSW_Context::alloc_node and alike

• 2024-09-29 12:36:00 +0200

  • After a failed attempt to create vector index temporary file remains and prevents further operation

• 2024-09-29 10:49:01 +0200

  • Assertion failure in ha_blackhole::position upon INSERT into blackhole table with vector index

• 2024-09-29 10:33:06 +0200

  • Invalid (old?) table or database name 't#i#00' upon creating RocksDB table with vector index

• 2024-09-29 10:27:33 +0200

  • Server crash in Index_statistics::get_avg_frequency upon EITS collection for vector index

• 2024-09-28 23:07:48 +0200

  • Number of indexes inside InnoDB differs from that defined in MariaDB after altering table with vector key

• 2024-09-25 20:22:17 +0200

  • Using varbinary as vector-storing column results in assertion failures

• 2024-09-21 11:57:19 +0200

  • Vector search fails to compile on s390x

• 2024-09-06 22:12:35 +0200

  • generous_furthest optimization

• 2024-09-14 11:55:53 +0200

  • trying to stabilize floating-point tests

• 2024-09-13 11:44:35 +0400

  • Disabled high-level indexes with Aria

• 2024-09-10 14:31:26 +0200

  • cleanup: TABLE_SHARE::lock_share() helper

• 2024-09-01 17:43:46 +0400

  • Simplified quick_rm_table() and mysql_rename_table()

• 2024-08-27 22:25:34 +0400

  • ALTER TABLE fixes for high-level indexes (iii)

• 2024-08-26 12:56:43 +0400

  • ALTER TABLE fixes for high-level indexes (ii)

• 2024-08-12 13:27:48 +0400

  • ALTER TABLE fixes for high-level indexes (i)

• 2024-08-15 23:11:23 +0200

  • AVX-512 support

• 2024-08-29 20:49:54 +0200

  • VEC_Distance_Cosine()

• 2024-08-29 15:27:59 +0200

  • rename VEC_Distance to VEC_Distance_Euclidean

• 2024-08-24 15:09:51 +0200

  • mhnsw: use plugin index options and transaction_participant API

• 2024-08-27 15:10:06 +0200

  • cleanup: index options don't need hton anymore

• 2024-09-11 19:32:38 +0200

  • cleanup: extract transaction-related part of handlerton

• 2024-08-25 14:07:44 +0200

  • cleanup: handlerton

• 2024-07-25 22:28:30 +0200

  • make rename test to work with InnoDB too

• 2024-07-25 22:14:59 +0200

  • pos-fixes for rename

• 2024-07-15 21:47:19 +0400

  • VECTOR indexes support for RENAME TABLE

• 2024-07-25 20:27:50 +0200

  • post-fixes for TRUNCATE

• 2024-07-06 00:37:37 +0400

  • Fixed TRUNCATE TABLE against VECTOR indexes

• 2024-07-05 13:45:44 +0400

  • Test insert ... select with vector index

• 2024-07-03 19:52:53 +0400

  • Disable VECTOR indexes with partitioned tables

• 2024-07-05 14:55:45 +0400

  • CREATE TABLE ... LIKE loses VECTOR index

• 2024-07-24 22:01:53 +0300

  • Vec_FromText and Vec_ToText

• 2024-07-25 21:52:33 +0300

  • Introduce String::append_float

• 2024-07-24 22:31:36 +0200

  • mhnsw: make the search less greedy

• 2024-07-22 21:24:11 +0200

  • cleanup search_layer()

• 2024-07-19 12:25:25 +0200

  • mhnsw: store coordinates in 16 bits, not 32

• 2024-07-18 14:43:47 +0200

  • UPDATE/DELETE post-fixes

• 2024-07-18 14:40:15 +0200

  • cleanup: prepare_for_insert() -> prepare_for_modify()

• 2024-07-16 15:15:17 +0200

  • Initial support for vector DELETE and UPDATE

• 2024-07-14 16:02:09 +0200

  • non-SIMD fallback

• 2024-07-17 17:16:28 +0200

  • mhnsw: inter-statement shared cache

• 2024-06-13 23:24:51 +0200

  • mhnsw: change storage format

• 2024-06-12 17:12:20 +0200

  • mhnsw: return an error if lazy neighbor read failed

• 2024-06-06 16:39:45 +0200

  • mhnsw: SIMD for euclidean distance

• 2024-06-11 12:58:41 +0200

  • mhnsw: configurable parameters

• 2024-06-08 11:03:08 +0200

  • InnoDB support for hlindexes and mhnsw

• 2024-06-07 19:12:08 +0200

  • mhnsw: cache start node too, don't push too much in pg_discard

• 2024-06-07 16:40:28 +0200

  • bugfix: properly reset db_plugin when hlindex discovery fails

• 2024-06-07 13:50:13 +0200

  • mhnsw: build indexes with the columns of exactly right size

• 2024-06-07 00:31:49 +0200

  • cleanups

• 2024-06-06 15:08:02 +0200

  • mhnsw: remove EXTEND_CANDIDATES and KEEP_PRUNED_CONNECTIONS

• 2024-06-06 14:50:17 +0200

  • mhnsw: search intermediate layers with ef=1

• 2024-06-05 17:55:24 +0200

  • mhnsw: fix the heuristic neighbor selection algorithm

• 2024-06-05 16:14:12 +0200

  • mhnsw: don't prefix blob ref array with its length

• 2024-06-05 14:59:25 +0200

  • mhnsw: don't create many empty layers

• 2024-06-05 13:31:58 +0200

  • mhnsw: remove a redundant loop and ha_update_row

• 2024-06-05 13:39:33 +0200

  • mhnsw: modify target's neighbors directly

• 2024-06-04 23:06:44 +0200

  • mhnsw: cache neighbors too

• 2024-06-05 12:12:28 +0200

  • mhnsw: don't guess whether it's insert or update

• 2024-06-04 14:47:52 +0200

  • mhnsw: refactor FVector* classes

• 2024-06-03 15:21:57 +0200

  • mhnsw: fix memory management

• 2024-06-03 11:22:21 +0200

  • mhnsw: simplify memory management of returned results

• 2024-06-01 00:17:05 +0200

  • misc changes

• 2024-02-17 17:03:30 +0200

  • Initial HNSW implementation

• 2024-05-29 21:12:23 +0200

  • cleanup: simplify Queue<>, add const

• 2024-07-12 10:38:48 +0200

  • cleanup: C++11 range-based for loop for Hash_set<>

• 2024-01-17 15:32:45 +0100

  • initial support for vector indexes

• 2023-11-25 14:58:06 +0100

  • VEC_DISTANCE() function

• 2024-07-18 14:43:06 +0200

  • cleanup: init_tmp_table_share(bool thread_specific)

• 2024-06-01 16:15:53 +0200

  • cleanup: thd->alloc<>() and thd->calloc<>()

• 2024-02-09 23:50:26 +0100

  • Revert " Segfault in heap_scan() upon UPDATE after ADD SYSTEM VERSIONING"

• 2024-01-26 12:19:47 +0100

  • cleanup: unused function argument

• 2024-01-27 00:15:40 +0100

  • open frm for DROP TABLE

• 2024-01-25 17:29:32 +0100

  • cleanup: extract ha_create_table_from_share()

• 2024-01-25 11:36:59 +0100

  • cleanup: generalize ER_INNODB_NO_FT_TEMP_TABLE

• 2024-01-17 15:48:53 +0100

  • cleanup: generalize ER_SPATIAL_CANT_HAVE_NULL

• 2024-01-18 01:30:12 +0100

  • cleanup: make_long_hash_field_name() and add_hash_field()

• 2024-01-14 11:43:43 +0100

  • cleanup: key algorithm vs key flags

• 2024-02-07 00:15:45 +0100

  • cleanup: Queue and Bounded_queue

• 2024-01-27 09:31:44 +0100

  • cleanup: lex_string_set3()

• 2024-01-10 20:31:43 +0100

  • cleanup: remove unconditional #ifdef's

• 2024-06-15 23:11:11 +0200

  • cleanup: const in List::push_front()

• 2024-01-08 19:33:32 +0100

  • reject invalid spatial key declarations in the parser

• 2024-01-26 16:05:38 +0100

  • cleanup: pass TABLE_SHARE to store_key_options()

• 2024-09-25 14:39:29 +0200

  • cleanup: get_float convenience helper

• 2024-10-06 12:28:54 +0200

  • cleanup: engine_option_value::Value::find_in_list() helper

• 2024-08-30 11:04:14 +0200

  • cleanup: CREATE_TYPELIB_FOR() helper

• 2024-01-08 18:29:12 +0100

  • cleanup: spaces, casts, comments

• 2024-09-26 11:52:05 +0200

  • memroot improvement: fix savepoint support

• 2024-08-26 19:27:45 +0200

  • fix a typo and an old bug in prefschema.transaction test

• 2024-02-05 16:29:32 +0100

  • fix main.plugin_vars test to cleanup after itself

• 2024-01-19 16:21:25 +0100

  • make INFORMATION_SCHEMA.STATISTICS.COMMENT not nullable

• 2024-11-02 11:34:35 +0100

  • fix for 32bit

• 2024-11-02 18:25:10 +0700

  • Unexpected error WARN_SORTING_ON_TRUNCATED_LENGTH or assertion failure in diagnostics area #2

• 2024-11-05 09:14:06 +0400

  • Adding a comment near the keyword NOCOPY

• 2024-11-02 10:27:48 +0400

  • Fixing main.type_timestamp failure with --view

• 2024-11-01 21:01:31 +0100

  • fix main.selectivity_notembedded --view

• 2024-11-01 20:52:58 +0100

  • fix the test for --view

• 2024-09-11 22:55:14 +0200

  • print more digits for floating point options in mariadbd --help

• 2023-12-31 12:41:25 +0200

  • Implement the Percona variable slow_query_log_always_write_time

• 2024-10-29 21:36:09 +0700

  • Unexpected WARN_SORTING_ON_TRUNCATED_LENGTH or assertion failure in diagnostics area

• 2024-10-29 09:52:42 +0400

  • NOCOPY has become reserved word bringing wide incompatibility

• 2024-10-27 14:07:59 +0400

  • Assertion `dec <= 6' failed in my_timestamp_binary_length

• 2024-10-29 14:22:59 +0400

  • perfschema.lowercase_fs_off fails on buildbot

• 2024-10-29 14:18:38 +0300

  • Allow converting a versioned table from implicit to explicit row_start/row_end columns

• 2024-09-12 11:54:24 +0200

  • post-merge changes

• 2024-02-28 19:09:58 +0100

  • Implement native UUID7 function

• 2024-06-25 17:17:13 +1000

  • UUID() should be treated as stochastic for the purposes of forcing query materialization

• 2024-04-04 06:22:06 +0400

  • cleanup: Implement native UUID4 function

• 2024-03-21 00:20:19 +0100

  • Implement native UUID4 function

• 2024-10-29 12:15:53 +0200

  • wsrep.wsrep-recover, wsrep.wsrep-recover-v25 fail on assertion

• 2024-08-29 11:10:59 +1000

  • : UPDATE/DELETE: Cost-based choice IN->EXISTS vs Materialization

• 2023-09-04 13:15:06 +0700

  • Add a warning when max_sort_length is reached

• 2024-08-17 12:56:28 +0400

  • Add a warning when max_sort_length is reached

• 2023-09-25 21:48:01 +0400

  • ROW data type for stored function return values

• 2024-08-26 13:24:59 +0400

  • CURRENT_TIMESTAMP should return a TIMESTAMP [WITH TIME ZONE?]

• 2024-10-18 14:05:29 +0200

  • fix rdiff files in sys_var suite

• 2024-10-18 13:58:37 +0200

  • fix client.client-env-variable test

• 2024-08-11 21:27:50 -0700

  • : Slave error message incorrectly mentions server_uuid

• 2024-10-17 15:52:41 -0600

  • : Fix mysqld--help,win.rdiff

• 2024-10-13 14:24:05 -0600

  • : typo fix in test

• 2024-09-14 21:26:55 +0200

  • test fix

• 2024-09-16 07:33:46 -0600

  • : Galera and SST/no binlog fixes

• 2024-09-12 14:19:33 -0600

  • : Reduce min val of large_commit_threshold for debug builds

• 2024-09-05 00:16:35 +0800

  • Rename binlog cache temporary file to binlog file for large transaction

• 2024-08-12 17:01:14 +1000

  • Implement SHOW CREATE SERVER

• 2024-09-05 16:12:35 +1000

  • Allow arbitrary options in CREATE SERVER

• 2024-08-07 17:27:15 +1000

  • Fix mysql.servers socket max length too short

• 2024-08-07 13:27:44 +1000

  • spider: some trivial cleanups and documentation

• 2019-06-27 02:16:33 +0400

  • json_get_object_nkey() function implemented.

• 2024-09-17 15:42:55 +1100

  • -fix column count issue with union in derived table

• 2024-09-16 12:58:33 +1100

  • name resolution fails in --view

• 2024-08-23 14:55:46 +1100

  • Add optional correlation column list for derived tables

• 2024-07-22 20:27:51 +0000

  • Update mini-benchmark to use constant transactions

• 2023-12-13 23:30:18 +0000

  • Make SESSION_USER() comparable with CURRENT_USER()

• 2024-07-15 18:54:55 +0000

  • [] Client programs to use $MARIADB_HOST consistently

• 2024-09-30 11:27:45 +0800

  • The revision corresponds to the review comments. 1. Move the unit tests into the compat/oracle suite, sp-param.test file. 2. Remove the added unit test file and result file. 3. Add type, Alter_info::enum_alter_table_algorithm, into the union. 4. Remove the extra switch case

• 2024-09-13 19:10:56 +0800

  • Fixed ALTER TABLE NOCOPY keyword failure

• 2024-09-09 17:52:52 +0800

  • sql_mode=ORACLE: Ignore the NOCOPY keyword in stored routine parameters

• Merge 2024-10-03 18:15:13 +0300 - Merge 11.6 into 11.7

• 2024-07-26 10:15:50 +0300

  • : Set optimizer_switch='cset_narrowing=on' by default

• 2024-09-10 14:48:59 +1000

  • Deprecate spider_table_crd_thread_count and spider_table_sts_thread_count

• 2024-06-11 22:59:31 +0800

  • Async rollback prepared transactions during binlog crash recovery

• 2024-08-31 01:34:52 +0200

  • : Implement --slave-abort-blocking-timeout

• Merge 2024-09-04 10:49:15 +0300 - Merge 11.6 into main

• 2024-07-11 11:53:03 -0600

  • : Deprecate binlog_optimize_thread_scheduling

• 2024-08-27 13:40:39 +0100

  • Update markdown files for main branch

• 2024-08-05 16:16:09 +0200

  • Quick mode produces the bug for mariadb client

• Merge 2024-08-21 15:26:07 +0200 - Merge branch '11.6' into 11.7

• 2024-08-20 08:41:24 +0200

  • 11.7 branch