Changelog for MariaDB Enterprise Server 10.6.19-15

(MENT-1304) No Method to Shrink ibdata1

(MENT-2031) Backport MDEV-30879 - Add conversion to based 62 for CONV function

(MENT-1897) Backport MDEV-26182 - Functions JSON_OBJECT_FILTER_KEYS, JSON_OBJECT_TO_ARRAY, JSON_ARRAY_INTERSECT

(MENT-1896) Backport MDEV-30145 - Function JSON_KEY_VALUE()

(MENT-2092) Backport Improvements/Bug fixes from MariaDB Backup of 10.11

(MDEV-33650) Q2 2024 release merge

(MDEV-34353) Revert changes for indefinite wait during signal handler under --bootstrap

(MDEV-34359) Spider: add tests for connection param overriding

(MDEV-34223) Innodb - add status variable for number of bulk inserts

(MDEV-34522) Index for (specific) Aria table is created as corrupted

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

(MDEV-34357) InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211

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

(MDEV-34187) 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-32376) SHOW CREATE DATABASE statement crashes the server when db name contains some Unicode characters, ASAN stack-buffer-overflow

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

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

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

(MDEV-34167) We fail to terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing

(MDEV-34222) Alter operation on redundant table aborts the server

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

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

(MDEV-34543) Shutdown hangs while freeing the asynchronous i/o slots

(MDEV-25607) Auto-generated DELETE from HEAP table can break replication

(MDEV-33921) Replication fails when XA transactions are used where the slave has replicate_do_db set and the client has touched a different database when running DML such as inserts.

(MDEV-29363) Constant subquery causing a crash in pushdown optimization

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

(MDEV-29962) SIGSEGV in ha_spider::lock_tables on BEGIN after table lock

(MDEV-32492) SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT, and SELECT

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

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

(MDEV-33010) Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table

(MDEV-23857) replication master password length

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

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

(MDEV-29027) ASAN errors in spider_db_free_result after partition DDL

(MDEV-22935) Erroneous Aria Index / Optimizer behavior

(MDEV-34417) Wrong result set with utf8mb4_danish_ci and BNLH join

(MDEV-34475) Disable new connections in case of fatal signal

(MDEV-34473) Enhanced network logging information shown as error instead of warning

(MDEV-34458) wait_for_read in buf_page_get_low hurts performance

(MDEV-34434) Hide password passed on command-line from xtrabackup_info

(MDEV-33465) an option to enable semi-sync recovery

(MDEV-33265) unknown variable 'defaults-group-suffix= with mariadb-secure-installation

(MDEV-34506) 2nd execution name resolution problem with pushdown into unions

(MDEV-34170) table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0

(MDEV-32158) wsrep_sst_mariabackup use /tmp dir during SST rather then user defined tmpdir

(MDEV-12008) Change error code for Galera unkillable threads

(MDEV-24411) Trigger doesn't work correctly with bulk insert

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

(MDEV-31658) Deadlock found when trying to get lock during applying

(MENT-2126) Cherry-Pick MDEV-34759 buf_page_get_low() is unnecessarily acquiring exclusive latch on secondary index pages

(MENT-2127) Cherry-pick fix for MDEV-34683

(MENT-2125) Cherry-Pick MDEV-34043 Drastically slower query performance between CentOS (2sec) and Rocky (48sec)

(MDEV-34474) InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound

(MDEV-34632) Assertion 'table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength' failed in void handler::assert_icp_limitations(uchar*)

(MENT-1967) Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log FIRST, end_log_pos xxx, Internal MariaDB error code: 1213

(MENT-2120) MSAN reports use-of-uninitialized-value on binlog_encryption.encrypted_master

(MENT-2131) Backport JSON_SCHEMA_VALID() bugs that were left.

(MDEV-34568) rpl.rpl_mdev12179 windows fix "File already exists"

(MDEV-34203) Sandbox mode - is not compatible with --binary-mode

(MDEV-34269) 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning

(MDEV-34129) mariadb-install-db appears to hang on macOS

(MENT-2121) Backport MDEV-34200 from 10.11 to 10.6-enterprise

(MDEV-34266) safe_strcpy() includes an unnecessary conditional branch

(MDEV-34580) Assertion '(key_part->key_part_flag & 4) == 0' failed key_hashnr

(MDEV-32782) galera_sst_mysqldump_with_key test failed

(MDEV-31566) Fix buffer overrun in dynstr_append_json_quote

(MDEV-33952) galera.galera_create_table_as_select fails sporadically

(MENT-2073) Backport MDEV-33609 to MariaDB Enterprise

(MDEV-34099) AddressSanitizer running out of memory regardless of stack_thread size

(MDEV-30623) JSON_TABLE in subquery not correctly marked as correlated

(MDEV-32456) incorrect result of GIS function in view protocol

(MDEV-30408) Spider test using semijoin=off returns wrong result (zero rows)

(MDEV-32424) Pushdown: server crashes at JOIN::save_explain_data()

(MDEV-32304) Pushdown: server crashes at Item_field::used_tables()

(MDEV-32293) Pushdown: server crashes at check_simple_equality()

(MDEV-31151) Inaccurate stack size calculation caused stack overflow in pinbox allocator

(MDEV-34190) ANALYZE: r_engine_stats shows unrealistically low pages_read_count

(MDEV-34519) innodb_log_checkpoint_now crashes when innodb_read_only is enabled

(MDEV-34181) Instant table aborts after discard tablespace

(MDEV-34625) MariaDB server crashes in 10.11.8 due to using uninitialized member variables

(MDEV-29010) Table cannot be loaded after instant ALTER, errors, or assertion failure

(MDEV-34305) Redundant truncation errors/warnings with optimizer_trace enabled

(MDEV-15393) gtid_slave_pos duplicate key errors after mysqldump restore

(MDEV-34505) galera.mariadb_tzinfo_to_sql fails deterministically on Ubuntu 24.04

(MDEV-21538) galera_desync_overlapped MTR failed: Result content mismatch

(MENT-1522) galera_nbo_local_mdl fails on FreeBSD with timeout

(MDEV-34634) Types mismatch when cloning items causes debug assertion

(MDEV-34449) spider/bugfix.mdev_28683 failing the valgrind build

(MDEV-34318) mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server

(MDEV-34664) InnoDB's doubling of rec_per_key estimates causes poor query plans

(MDEV-28345) ASAN: use-after-poison or unknown-crash in my_strtod_int from charset_info_st::strntod or test_if_number

(MDEV-34604) mytop - fix specifying filters in .mytop

(MDEV-21166) Creating and running a mroonga function causes various crashes, UBSAN member call on null pointer, UBSAN access within null pointer

(MDEV-32892) IO Thread Reports False Error When Stopped During Connecting to Primary

(MDEV-30027) [Draft] rpl.rpl_semi_sync_shutdown_await_ack fails when --mysqld=--debug is set

(MDEV-19052) Range-type window frame supports only numeric datatype

(MDEV-32608) Expression with constant subquery causes a crash in pushdown from HAVING

(MDEV-32738) Inconsistency in Galera cluster while running add drop column

(MDEV-34477) galera.galera_gcache_recover_manytrx sporadic test failures

(MDEV-34510) UBSAN: crc32 x86 - integer overflow

(MDEV-34490) get_copy() and build_clone() may return an instance of a ancestor class instead of a copy/clone

(MDEV-34041) Additional information for materialized subqueries must be displayed in EXPLAIN/ANALYZE FORMAT=JSON

(MDEV-34539) Invalid "use" and "Schema" in slow query log file with multi-line schema

(MDEV-34530) dead code in the thr_rwlock.c

(MDEV-34384) restorecon call in RPM POSTIN script has hard-coded datadir path

(MDEV-34542) Assertion 'lock_trx_has_sys_table_locks(trx) == __null' failed in void row_mysql_unfreeze_data_dictionary(trx_t*)

(MDEV-34066) Output of SHOW ENGINE INNODB STATUS uses the nanoseconds suffix for microseconds

(MDEV-34372) Starting MariaDB failed with illegal instruction in WolfSSL

(MENT-1504) Spider and Spider/ODBC: Fix some minor English grammar typo's

(MDEV-34143) Server crashes when executing JSON_EXTRACT after setting non-default collation_connection

(MDEV-28800) SIGABRT due to running out of memory for InnoDB locks

(MDEV-34265) Possible hang during IO burst with innodb_flush_sync enabled

(MDEV-34166) Server could hang with BP < 80M under stress

(MDEV-27186) Assertion '!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())' failed in Diagnostics_area::set_eof_status when using spider partitioning, and Assertion '! is_set()' failed in Diagnostics_area::set_eof_status

(MDEV-33064) ALTER INPLACE running TOI doesn't abort a DML operation in InnoDB

(MDEV-30931) UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in get_interval_value on SELECT

(MDEV-34397) "delete si" rather than "my_free(si)" in THD::register_slave()

(MDEV-34283) A misplaced btr_cur_need_opposite_intention() check may fail to prevent hangs

(MDEV-33119) User is case insensitive in INFORMATION_SCHEMA.VIEWS

(MDEV-33120) System log table names are case insensitive with lower-cast-table-names=0

(MDEV-33110) HANDLER commands are case insensitive with lower-case-table-names=0

(MDEV-33108) TABLE_STATISTICS and INDEX_STATISTICS are case insensitive with lower-case-table-names=0

(MDEV-33109) DROP DATABASE MYSQL -- does not drop SP with lower-case-table-names=0

(MDEV-33088) Cannot create triggers in the database 'MYSQL`

(MDEV-33086) SHOW OPEN TABLES IN DB1 -- is case insensitive with lower-case-table-names=0

(MDEV-33084) LASTVAL(t1) and LASTVAL(T1) do not work well with lower-case-table-names=0

(MDEV-33085) Tables T1 and t1 do not work well with ENGINE=CSV and lower-case-table-names=0

(MDEV-34014) mysql_upgrade failed

(MDEV-29307) Wrong result when joining two derived tables over the same view

(MDEV-34057) Inconsistent FTS state in concurrent scenarios

(MDEV-34381) During innodb_undo_truncate=ON recovery, InnoDB may fail to shrink undo* files

(MDEV-34428) main.winservice_basic fails with [Warning] Could not remove temporary table: '<path>', error: 2

(MDEV-34108) Inappropriate semi-consistent read in RC if innodb_snapshot_isolation=ON

(MDEV-33935) Innodb_deadlocks status variable counts wrong

(MDEV-34404) Spider: UBSAN: runtime error: null pointer passed as argument 2, which is declared to never be null in spider_create_string on SELECT

(MDEV-34125) ANALYZE FORMAT=JSON: r_engine_stats.pages_read_time_ms has wrong scale

(MDEV-33103) LOCK TABLE t1 AS t2 -- alias is not case sensitive with lower-case-table-names=0

(MDEV-32583) UUID() should be treated as stochastic for the purposes of forcing query materialization

(MDEV-20548) Unexpected error on CREATE..SELECT HEX(num)

(MDEV-34053) privilege REPLICA MONITOR issue

(MDEV-33523) Spurious deadlock error when wsrep_on=OFF

(MDEV-20053) galera_recovery: Wrong @sbindir@

(MDEV-7111) Unable to detect network timeout in 10.x when using SSL (regression from 5.5)

(MDEV-34313) WITHOUT_SERVER cannot compile mariadb-binlog

(MDEV-28162) clang compiler emits atomic library calls on x86/32bit

(MDEV-34437) SIGSEGV in vio_get_normalized_ip when using extra-port

(MDEV-34502) InnoDB Debug build under valgrind errors on assertions

(MDEV-33746) macOS virtual override markings missing

(MDEV-9159) assert() in semisync.master.cc

(MDEV-34205) ASAN stack-buffer-overflow in strxnmov | frm_file_exists

(MDEV-33490) Syntax errors in Spider error messages

(MDEV-34361) wait for slave timeout when running mtr --reorder spider.connection_override spider.slave_trx_isolation

(MDEV-34307) Recovery or mariadb-backup --prepare debug failure [FATAL] InnoDB: Page ... still fixed or dirty

(MDEV-34204) Assertion '!*detailed_error' failed in void trx_t::assert_freed() const

(MDEV-33161) Function pointer signature mismatch in LF_HASH

(MDEV-34321) UBSAN runtime error: call to function crc32c_3way through pointer to incorrect function type

(MDEV-34389) Don't write FILE_CHECKPOINT during early recovery when InnoDB log file in insufficient

(MDEV-34435) Increase code coverage for debug_dbug test case during startup

(MDEV-33574) mysqlbinlog -R not working

(MDEV-34355) rpl.rpl_semi_sync_no_missed_ack_after_add_slave "server_3 should have sent..."

(MDEV-34237) On Startup: UBSAN: runtime error: call to function MDL_lock::lf_hash_initializer lf_hash_insert through pointer to incorrect function type 'void (*)(st_lf_hash *, void *, const void *)'

(MDEV-34365) UBSAN runtime error: call to function io_callback(tpool::aiocb*)

(MDEV-34360) Columnstore should not be build on 32 bit systems

(MDEV-33078) SysInfo.pm reports incorrect CPU count on macOS

(MDEV-33919) Remonve an-trap from man pages

(MDEV-33602) rpl.rpl_gtid_stop_start At line 187: sync_with_master failed: 'select master_pos_wait('master-bin.000005', 1186, 300, '')' returned NULL indicating slave SQL thread

(MDEV-34175) mtr_t::log_close() warning should change the shutdown condition

(MDEV-34221) Errors about checksum mismatch on crash recovery are confusing

(MDEV-34169) Don't allow innodb_open_files to be lesser than number of non-user tablespace.

(MDEV-34236) Mroonga build will hang during MariaDB build when using GCC 12

(MDEV-34295) CAST(char_col AS DOUBLE) prints redundant spaces in a warning

(MDEV-27966) Assertion 'fixed()' failed and Assertion 'fixed ==  1' failed, both in Item_func_concat::val_str on SELECT after INSERT with collation utf32_bin on utf8_bin table

(MDEV-32176) Contention in ha_innobase::info_low (dict_table::lock_mutex_lock)

(MDEV-34296) extern thread_local is a CPU waste

(MDEV-34297) get_rnd_value() of ib_counter_t is unnecessarily complex

(MDEV-34178) Performance regression with IO-bound insert benchmark

(MDEV-34443) ha_innobase::info_low() does not distinguish HA_STATUS_VARIABLE_EXTRA

(MDEV-34311) ALTER USER should reset password errors counters

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

(MDEV-34670) IMPORT TABLESPACE unnecessarily traverses tablespaces list

(MDEV-33875) ORDER BY DESC causes ROWID Filter optimization performance degradation