• The option is now a system variable, and the tx_isolation system variable is deprecated (MDEV-21921)

InnoDB

• Server crashes in st_join_table::choose_best_splitting (MDEV-31403)

• Crash with condition pushable into derived and containing outer reference (MDEV-31240)

• InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)

• InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)

• is not updated correctly ()

• InnoDB monitor trx_rseg_history_len was accidentally disabled by default ()

• Revert " : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"

Optimizer

• Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)

• Crash with for multi-table update of system table (MDEV-31224)

Security

• Fixes for the following :

  • CVE-`-```

Changelog

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

Contributors

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

Do not use non-stable (non-GA) releases in production!

Storage Engines

InnoDB

• now builds indexes more efficiently (MDEV-33087)

  • Unsetting the system variable restores the old behavior.

• Fix unexpected storage read IO for the redo log, reintroduce (MDEV-33894)

• Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing ()

• Alter operation on redundant table no longer aborts the server ()

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

• Fix InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound ()

• wait_for_read in buf_page_get_low no longer hurts performance ()

• Fix InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211 ()

Aria

• Fix index corruption when doing a REPAIR TABLE that has a size of over 4G (MDEV-34522)

Spider

• UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT (MDEV-31475)

• SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)

• SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in spider_db_mbase::fin_loop_check on SHOW TABLE STATUS ()

• SIGSEGV in ha_spider::lock_tables on BEGIN after table lock ()

• SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and SELECT ()

• Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's ()

• Spider: @@insert_id 128 to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. ()

• ASAN errors in spider_db_free_result after partition DDL ()

• Server crashes when calling spider UDF after aria_encrypt_tables is enabled ()

Partitioning

• MariaDB Server crashes with ill-formed partitions (MDEV-32155)

• SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER (MDEV-34421)

• Assertion ``auto_increment_value'failed inha_partition::info` on INSERT into MEMORY table (MDEV-24610)

Character Sets

• On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations (MDEV-34226)

• On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci (MDEV-34187)

• SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow ()

• Wrong result set with utf8mb4_danish_ci and BNLH join ()

Optimizer

• On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc (MDEV-34227)

• Crash after killing query while it is processed by test_quick_select (MDEV-30651)

• Extend condition normalization to include 'NOT a' (MDEV-19520)

• Constant subquery causing a crash in pushdown optimization ()

• Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table ()

• 2nd execution name resolution problem with pushdown into unions ()

• Assertion ``(key_part->key_part_flag & 4) == 0'` failed key_hashnr ()

• Crash caused by query containing constant having clause ()

• Using NAME_CONST() (or executing query from the stored procedure and referring to a local variable) changes the plan and may make execution slower ()

• ORDER BY DESC causes ROWID Filter optimization performance degradation ()

• Auto-generated from table no longer breaks replication (MDEV-25607)

• Fix replication failure when are used where the replica has set and the client has touched a different database when running DML such as inserts. (MDEV-33921)

• Fix replication error when is used in conjunction with a password longer than 41 ascii characters (MDEV-23857)

• The option is utilized to avoid a possible error state in ()

Backup

• Hide password passed on commandline from xtrabackup_info (MDEV-34434)

Galera

• Galera updated to 26.4.19

  • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated

• galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` (MDEV-32633)

• table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0 ()

• Deadlock found when trying to get lock during applying ()

• Change error code for Galera unkillable threads ()

• 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning ()

• wsrep_sst_mariadb-backup use /tmp dir during SST rather then user defined tmpdir ()

Error Log

• system variable added, and value added to the at startup (MDEV-34494)

General

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.1 for Debian 10 "Buster", RHEL/CentOS 7, Ubuntu 23.10 "Mantic", and Fedora 38

• Repositories for Ubuntu 24.04 "Noble" have been added

• IMPORT TABLESPACE no longer unnecessarily traverses tablespaces list (MDEV-34670)

• Fix unknown variable defaults-group-suffix= with ()

• no longer hangs on macOS ()

• Fix transaction termination with ER_LOCK_TABLE_FULL when lock memory is growing ()

• Disable new connections in case of fatal signal ()

• Control over memory allocated for SP/PS ()

• now work correctly with bulk insert ()

• Fix assertion ``table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength'failed invoid handler::assert_icp_limitations(uchar*)` ()

• - now compatible with ()

Security

• Fixes for the following :

  • CVE-`-```

Changelog

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

Contributors

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

From this version, the tool adds a new command to the top of every dump file. This command cannot be interpreted by MariaDB command line client versions that do not have the sandbox command, or by MySQL command line clients, and an error will be generated in these clients. Other methods of importing the dump will work not have this issue.

Storage Engines

InnoDB

• Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) (MDEV-33515)

• Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL (MDEV-32899)

• Fix adaptive hash index corruption after (MDEV-33400)

• Server no longer aborts while altering an InnoDB statistics table ()

• Fix LeakSanitizer errors in rec_copy_prefix_to_buf ()

• Fix InnoDB fatal error: Clustered record field for column x not found ()

• Fix InnoDB hang when temporarily running out of buffer pool ()

• Fix alter operation hang when encryption thread works on the same tablespace ()

• Fix MariaDB segfault on rowid filter query involving generated column ()

• Fix discard/import tablespace, restart, index corruption ()

• Fix server hang on DROP INDEX or RENAME INDEX ()

• Fix mariadb-backup --backup hang ()

• Fix server hang caused by InnoDB change buffer ()

• Fix assertion failures upon adding a too long key to table with COMPRESSED row format ()

• IMPORT TABLESPACE no longer fails with column count or index count mismatch ()

• Fix alter table corruption while applying the modification log ()

• Fix inconsistent behaviors of UPDATE under RU & RC isolation level ()

• Fix weird SELECT view when a record is modified to the same value by two transactions ()

• Fix inconsistent read and write, which use the same predicate (WHERE clause) ()

• Fix inconsistent SELECT view when modifying a record added by another transaction ()

• Fix weird read view after ROLLBACK of other transactions ()

• Read only server no longer throws error when running a create temporary table as select statement ()

• Change buffer index no longer fails to delete the records ()

• Fix InnoDB include OS error information when failing to write to iblogfile0 ()

• Fix phantom rows caused by UPDATE of PRIMARY KEY ()

  • New system variable,

• In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values ()

• Fix InnoDB log corruption before upgrading it on startup ()

• Table no longer gets rebuilt with ALTER TABLE ADD COLUMN ()

• Fixed that internal temporary tables did not wait for freed disk space, and related issues (MDEV-33813)

• Fix wrong result on 2nd execution of prepared statement for query with derived table (MDEV-31361)

• Improve Spider performance by pushing down function (MDEV-28992) and statement (MDEV-28993) to data nodes

• Fix server crash when deleting partitions from a table with spider engine (MDEV-33731)

• SPIDER plugin initialization no longer fails at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720 (MDEV-33242)

• Fix spider plugin init failure with no_zero_date sql_mode ()

• Fix sql plugin init failure with traditional sql_mode ()

• Fix parsing failure on valid left join select by translating the on expression to () ()

• Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using local and remote ()

• Fix bug where were not available if Spider was loaded upon server startup ()

Backup

• Port backup features from Enterprise Server. This adds support for to MariaDB Backup, and obsoletes the no-backup-locks and rysnc options (MDEV-32932)

• MariaDB Backup now preserves (MDEV-33334)

• Fix MariaDB Backup problem on older mariadb (opendir(NULL)) caused by MDEV-30968 (MDEV-31251)

• Fix FATAL ERROR: ... Can't open datafile cool_down/t3 ()

• now includes retry logic for undo tablespaces ()

• Fix crash recovery in mariadb-backup --prepare due to insufficient ()

• Fix crash in after --prepare ()

• now considers O/S user when --user option is omitted ()

,

• Fixed improper application of COLLATE to non-character columns (MDEV-33318)

• Default charset now works with PHP MySQLi extension (MDEV-32975)

• Fixed Bad SEPARATOR value in on character set conversion (MDEV-33772)

• Fixed out of range error in (()) due to a wrong data type (MDEV-33496)

• Fixed and problems with ()

JSON

• View created via now returns correct json object (MDEV-30646)

• now detects the type of String Values and correctly returns Date/DateTime values (MDEV-19487)

• no longer returns NULL on valid arguments (MDEV-22141)

• no longer returns multiple values for same path (MDEV-32287)

Encryption, TLS, SSL

• WolfSSL's math is unnecessarily slow (MDEV-33482)

Optimization & Tuning

• Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables (MDEV-21102)

• Wrong result with cross Join given join order (MDEV-30975)

• Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT (MDEV-31276)

• Wrong result with semi-join and splittable derived table (MDEV-23878)

• Optimizer choosing incorrect index in 10.6, 10.5 but not in 10.4 ()

• Aggregation functions fail to leverage uniqueness property ()

• Partitioning is broken on big endian architectures ()

Plugins

• The now reports the user and host in all cases (MDEV-33393)

Replication

• --gtid-ignore-duplicate can double-apply event in case of parallel replication retry (MDEV-33475)

• Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure (MDEV-34042)

• mysql_manager_submit Segfault at Startup Still Possible During Recovery (MDEV-33799)

• Server crash in Rows_log_event::update_sequence upon replaying binary log (MDEV-31779)

• Slave crashed:reload_acl_and_cache during shutdown ()

• Rpl_semi_sync_slave_status is ON When Replication Is Not Configured ()

• When binlog_annotate_row_events on , event of binlog file is truncated ()

• Add more warnings to be able to better diagnose network issues ()

• Improve times and states in show processlist for replication ()

• Adapt parallel slave's round-robin scheduling to XA events ()

• release row locks for non-modified rows at XA PREPARE ()

• Semi-sync Wait Point AFTER_COMMIT Slow on Workloads with Heavy Concurrency ()

Galera

• Galera updated to 26.4.18

  • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated

• Disallow bulk insert operation during partition update statement (MDEV-33979)

SQL, Data Definition, and Data Manipulation

• Transportable Tablespaces no longer leave in a mismatched state (MDEV-18288)

• Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)

• Fix incorrect DEFAULT expression evaluated in (MDEV-33790)

• Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack (MDEV-33622)

• Fix incorrect handling of in PS mode when a table's column declared as NOT NULL ()

• Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT ()

• Fix wrong result on 2nd execution of PS to select from view using derived ()

• Fix wrong warnings on 2nd execution of PS for query with GROUP_CONCAT ()

• value of '1970-01-01 00:00:00' can no longer be indirectly inserted in ()

• Fix out of range error in (()) due to a wrong data type ()

• Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp ()

• unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' ()

• Fix crash using UDF in WHERE clause of VIEW ()

• Fix update for portion changes autoincrement key in period table ()

• Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE ()

Platforms & Packaging

• MariaDB-client community can't be installed in red hat ubi9 (MDEV-32791)

General

Scripts & Clients

• It's now possible to disable system commands with the option. (MDEV-21778)

• now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)

• commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)

• Loading now works with INPLACE ()

Server

• Moving from MariaDB 10.5 to 10.6 mysql_upgrade is not updating some system tables (MDEV-33726)

• Original IP not shown in network related error messages when proxy_protocol is in use (MDEV-33506)

• Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup (MDEV-33469)

• update case insensitive (large) unique key with insensitive change of value - duplicate key (MDEV-29345)

• MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params ()

• Slowdown when running nested statement with many partitions ()

Security

• Fixes for the following :

  • CVE-2024-21096

Changelog

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

Contributors

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

Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types (MDEV-32879)

wsrep_provider_options can be truncated on deep and long directory paths (MDEV-32634)

InnoDB

• followed by may corrupt data (MDEV-32132)

• ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. (MDEV-31875)

• Server aborts during alter operation when table doesn't have foreign index (MDEV-32527)

• row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently (MDEV-32578)

• InnoDB: tried to purge non-delete-marked record of an index on a virtual column prefix ()

• lock_row_lock_current_waits counter in information_schema.innodb_metrics may become negative ()

• SET GLOBAL innodb_max_purge_lag_wait=… hangs if innodb_read_only=ON ()

• Auto-increment no longer works for explicit FTS_DOC_ID ()

• Assertion `pos < table->n_def' failed in dict_table_get_nth_col ()

• innochecksum man pages seem to be inconsistent with the binary (10.2.25) ()

• innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error ()

• wrong table name in innodb's "row too big" errors ()

• Optimize is_file_on_ssd() to speedup opening tablespaces on Windows ()

• Race condition between page write completion and log checkpoint ()

• After crash recovery, Checksum mismatch + Failing assertion: !i || prev_id + 1 == space_id, ()

• Deadlock due to log_free_check(), involving trx_purge_truncate_rseg_history() and trx_undo_assign_low() ()

• Write-ahead logging is broken for freed pages ()

• X-lock on supremum for prepared transaction for RR ()

• Assertion failures in log_sort_flush_list upon crash recovery ()

• Race condition between page write completion and log checkpoint ()

• Assertion `purge_sys.tail.trx_no <= purge_sys.rseg->last_trx_no()' ()

• Assertion `index->is_btree() || index->is_ibuf()' failed in btr_search_guess_on_hash ()

• InnoDB hang in buf_flush_wait_LRU_batch_end() ()

• InnoDB may hang when running out of buffer pool ()

• Corrupt index(es) on busy table when using FOREIGN KEY ()

• InnoDB Recovery doesn't display encryption message when no encryption configuration passed ()

• Wrong information about innodb_checksum_algorithm in the information_schema.SYSTEM_VARIABLES ()

• InnoDB may fail to recover after being killed in fil_delete_tablespace() ()

• Create separate tpool thread for async aio ()

• UNDO logs still growing for write-intensive workloads ()

  • Increase the default for from 300 to 1000 ()

  • Deprecate .

  • The motivation for introducing this in MySQL seems to have been to avoid stalls due to freeing undo log pages or truncating undo log tablespaces. In MariaDB, should be a much lighter operation because it will not involve any log checkpoint. (

• Slow full index scan in 10.6 vs 10.5 for the (slow) I/O-bound case ()

• LOAD DATA into InnoDB w/partitions: huge performance loss, affected 10.6+ ()

• Disable read-ahead for temporary tablespace ()

Optimizer

• New setting, cset_narrowing, to enable the (MDEV-32113)

• Crash when HAVING in a correlated subquery references columns in the outer query (MDEV-29731)

• Server crashes at TABLE::add_tmp_key (MDEV-32320)

• Server crashes inside filesort at my_decimal::to_binary ()

• Assertion `bitmap_is_set(&m_part_info->read_partitions, m_part_spec.start_part)' failed in ha_partition::handle_ordered_index_scan ()

• Crash when searching for the best split of derived table ()

• Test case from opt_tvc.test fails with statement memory protection ()

• Significant slowdown for query with many outer joins ()

• test_if_skip_sort_order() should catch the join types JT_EQ_REF, JT_CONST and JT_SYSTEM and skip sort order for these ()

• jointable materialization subquery optimization ignoring errors, then failing ASSERT. ()

• Server crashes in JOIN::cleanup after erroneous query with view ()

• Prepared statement return wrong result (missing row) ()

• Assertion `range->rows >= s->found_records' failed in best_access_path ()

Replication

• rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables (MDEV-10356)

• Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication (MDEV-31482)

• strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT (MDEV-32249)

• Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE (MDEV-31792)

• SHOW SLAVE STATUS Last_SQL_Errno Race Condition on Errored Slave Restart ()

• seconds_behind_master is inaccurate for Delayed replication ()

• detailize the semisync replication magic number error ()

• Parallel replication deadlock victim preference code errorneously removed ()

• Parallel replication lags because innobase_kill_query() may fail to interrupt a lock wait ()

Galera

• Galera updated to 26.4.16

• Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. (MDEV-24912)

• Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed (MDEV-31285)

• wsrep_sst_mariadb-backup not working on FreeBSD (MDEV-31467)

• Galera library 26.4.16 fails with every server version ()

• Galera node remains paused after interleaving FTWRLs ()

• Failed to insert streaming client ()

• When set at runtime, accepts any value ()

• galera needs packaging script changes to successfully build ()

• replication breaks when using optimistic replication and replica is a galera node ()

• McAfee database vulnerability scan caused MariaDB crash with signal 6 (system abort) ()

• Assertion `mode_ == m_local || transaction_.is_streaming()' failed in int wsrep::client_state::bf_abort(wsrep::seqno) ()

Data Definition

• MariaDB crash on calling function (MDEV-23902)

• ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations (MDEV-31970)

• vcol circular references lead to stack overflow (MDEV-31112)

• OPTIMIZE TABLE crash (MDEV-28122)

• Server crashes in Alter_info::add_stat_drop_index upon CREATE TABLE ()

Scripts and Clients

• (mysqlbinlog) option (MDEV-25369)

• (mysqladmin) wrong error with (MDEV-22418)

• shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)

• main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 (MDEV-19369)

• (mysql_install_db) doesn't properly grant to all default root user accounts ()

Tests

• main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)

• main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)

• main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)

• main.secure_file_priv_win fails with 2nd execution PS protocol (MDEV-32023)

• Windows : mtr output on is messed up with large MTR_PARALLEL ()

• main.mysql_client_test_comp failed in buildbot, error on exec ()

• main.order_by_pack_big fails with view-protocol ()

• mysql_install_db_win.test fails on second execution ()

mariadb-backup

• mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)

• mbstream breaks page compression on XFS (MDEV-25734)

Character Sets, Data Types, Collations

• Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)

• Inconsistent results of DISTINCT with NOPAD (MDEV-30050)

• Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)

• Compressed varchar values lost on joins when sorting on columns from joined table(s) (MDEV-31724)

• UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()

• Wrong bit encoding using COALESCE ()

Spider

• Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)

• Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows (MDEV-31996)

• ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)

• ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 ()

General

• option breaks importing sql dumps (MDEV-29989)

• Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 (MDEV-32025)

• getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO (MDEV-32275)

• Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT (MDEV-17711)

• main.mysqlcheck fails on ARM with ASAN use-after-poison in my_mb_wc_filename ()

• main.delayed fails with wrong error code or timeout when executed after main.deadlock_ftwrl ()

• Assertion failed: !pfs->m_idle || (state == PSI_SOCKET_STATE_ACTIVE) ()

• MyISAM wrong server status flags ()

• Server crashes in check_sequence_fields upon CREATE TABLE .. SEQUENCE=1 AS SELECT .. ()

• slow log Rows_examined out of range ()

• "rpm --setugids" breaks PAM authentication ()

• incorrect examined rows in case of stored function usage ()

• Compilation failing on MacOS (unknown warning option -Wno-unused-but-set-variable) ()

• Server crash upon inserting into Mroonga table with compressed column ()

• hash unique corrupts index on virtual blobs ()

• insert into an empty table fails with hash unique ()

• Valgrind/MSAN warnings in dynamic_column_update_move_left ()

• Memory leak showed in test suite ()

• Test from subselect.test fails with statement memory protection ()

• Memory leak when executing PS for query with IN subquery ()

• Allow the setting of Auto_increment on FK referenced columns ()

• mariadb-upgrade fails with sql_safe_updates = on ()

• Assertion `!(thd->server_status & (1U | 8192U))' failed in MDL_context::release_transactional_locks ()

• Information schema leaks table names and structure to unauthorized users ()

• Missing CHACHA20-POLY1305 support in WolfSSL ()

• incorrect error about cyclic reference about JSON type virtual column ()

• Disable TLS v1.0 and 1.1 for MariaDB ()

• Better indication of refusing to start because of ProtectHome ()

• Database upgrade fails: slow_log table ()

• myrocks_hotbackup.1 and test suite files installed when engine is disabled ()

• client_ed25519.dll isn't inluded for HeidiSQL. ()

• Assertion `!m_null_value' failed in int FixedBinTypeBundle::cmp_item_fbt::compare or in cmp_item_inet6::compare ()

• type_test.type_test_double fails with 'NUMERIC_SCALE NULL' ()

• LeakSanitizer errors in get_quick_select or Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed ()

• Update signal hander user info more compassion and correct url ()

• maria-install-db fails on MacOS ()

• MSAN / Valgrind errors in Item_func_like::get_mm_leaf upon query from partitioned table ()

• MSAN / Valgrind errors in Item_func_like::get_mm_leaf with temporal field ()

• ASAN errors in base_list_iterator::next / setup_table_map upon 2nd execution of PS ()

• safe_mutex: Found wrong usage of mutex 'LOCK_thd_data' and 'wait_mutex' ()

Docker Official Images

• Invert single and double quotes for sql command definitions in due to failure under - contribution by Dominik Häckel

• --no-defaults behaviour was corrected - reported by Dominik Häckel

• Added /docker-entrypoint-init.d for tar{,compression} from MariaDB Backup -

• Refactor docker_mariadb_init in the entrypoint for extending the MariaDB image

• CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1

• Add for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini

• added --galera_online test, to match what the does.

Variables

• Added the system variable to manage notes when an index cannot be used.

Security

• Fixes for the following :

  • CVE-2023-22084

Changelog

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

Contributors

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

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}