Changelog for MariaDB Enterprise Server 10.5.27-21

(MDEV-35030) Q4 2024 release merge

(MDEV-28894) Spider: remove #ifdef HA_EXTRA_HAS_STARTING_ORDERED_INDEX_SCAN

(MDEV-28895) Spider: remove #ifdef HANDLER_HAS_CAN_USE_FOR_AUTO_INC_INIT

(MDEV-28896) Spider: remove #ifdef SPIDER_UPDATE_ROW_HAS_CONST_NEW_DATA

(MDEV-28892) Spider: remove #ifdef SPIDER_Item_args_arg_count_IS_PROTECTED

(MDEV-28893) Spider: remove #ifdef SPIDER_NET_HAS_THD

(MDEV-34100) backport MDEV-26912 Spider: Remove dead code related to Oracle OCI

(MDEV-27650) Spider: remove #ifdef SPIDER_HAS_GROUP_BY_HANDLER

(MDEV-34828) Fix-up on MDEV-26858 by removing some remnant obsolete code related to spider handlersocket support

(MDEV-14959) Control over memory allocated for SP/PS

(MDEV-31788) Factor out code repeat in functions calling spider_check_and_init_casual_read()

(MDEV-34704) Quick mode produces the bug for mariadb client

(MDEV-16699) heap-use-after-free in group_concat with compressed or GIS columns

(MDEV-23983) Crash caused by query containing constant having clause

(MDEV-34682) Server crashes when calling spider UDF after aria_encrypt_tables is enabled

(MDEV-34938) Under Windows Subsystem for Linux, InnoDB crashes on ALTER TABLE or OPTIMIZE TABLE

(MDEV-31173) Server crashes when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table

(MDEV-34814) mysqld hangs on startup when --init-file target does not exists

(MDEV-35276) Assertion failure in find_producing_item upon a query from a view

(MDEV-33470) Unique hash index is broken on DML for system-versioned table

(MDEV-32363) when InnoDB gets an assertion failure, WSREP layer is not handled gracefully

(MDEV-27037) Mysqlbinlog should output a warning if EOF is found before its stop condition

(MDEV-34392) modification of the column fails to check foreign key constraint

(MDEV-29537) Creation of view with UNION and SELECT ... FOR UPDATE in definition is failed with error

(MDEV-34647) INSERT...SELECT' on MyISAM table suddenly replicated by Galera

(MDEV-26345) SELECT MIN on Spider table returns more rows than expected

(MDEV-32350) Can't selectively restore sequences using innodb tables from backup

(MDEV-34883) LOAD DATA INFILE with geometry data fails

(MDEV-34718) Trigger doesn't work correctly with bulk update

(MDEV-34802) Recovery fails to note some log corruption

(MDEV-35122) Incorrect NULL value handling for instantly dropped BLOB columns

(MENT-2164) Cherry-pick MDEV-35157 "wrong binlog timestamps on secondary nodes of a galera cluster", which will be in 10.6.21 CS

(MENT-2181) Cherry pick MDEV-35507 for server_auditv2 - ed25519 authentication plugin create user statement trigger plain text password in audit log

(MENT-2188) cherry-pick and change for audit v2 MDEV-35522

(MDEV-29546) spider group by handler wrong result on order by aggregate

(MDEV-34808) Update HeidiSQL to v12.8

(MDEV-35040) A std::unique_ptr declaration is incompatible with clang++-20 -stdlib=libc++

(MDEV-28288) System versioning doesn't support correct work for engine=connect and doesn't always give any warnings/errors

(MDEV-34943) Disable Automatic Replication start in Docker Official Image docker-entrypoint/initdb.d

(MDEV-32778) galera_ssl_reload failed with warning message

(MDEV-34696) do_gco_wait() completes too early on InnoDB dict stats updates

(MDEV-34565) MariaDB crashes with SIGILL because the OS does not support AVX512

(MDEV-33106) innodb.innodb-lock-inherit-read_commited fails with timeout

(MENT-2167) galera_nbo_drop_table_concurrent test failed

(MENT-2173) Timeouts in the galera_as_slave_ctas test

(MDEV-27944) View-protocol fails if database was changed

(MDEV-33997) Assertion ((WSREP_PROVIDER_EXISTS_ && this->variables.wsrep_on) && wsrep_emulate_bin_log) || mysql_bin_log.is_open() failed in int THD::binlog_write_row(TABLE*, bool, const uchar*)

(MDEV-34841) Enable working Galera tests

(MDEV-25614) Galera test failure on GCF-354

(MDEV-34234) Delayed SST when running on unprivileged containers on RHEL9

(MDEV-34976) Server crash report broken if Galera is not loaded

(MDEV-33373) Unexpected ER_FILE_NOT_FOUND upon reading from logging table after crash recovery

(MDEV-24193) UBSAN: sql/sql_acl.cc:9985:29: runtime error: member access within null pointer of type 'struct TABLE' , ASAN: use-after-poison in handle_grant_table

(MDEV-35050) Found wrong usage of mutex upon setting plugin session variables

(MDEV-35074) main.selectivity_notembedded and main.selectivity_innodb_notembedded fail with view protocol

(MDEV-31297) Create table as select on system versioned tables do not work consistently on replication

(MDEV-25060) Freeing overrun buffer, various crashes, ASAN heap-buffer-overflow in _mi_put_key_in_record

(MDEV-35086) Trying to lock mutex when the mutex was already locked (session_tracker.cc), server hangs

(MDEV-35082) HANDLER with FULLTEXT keys is not always rejected

(MDEV-18151) Skipped error returning for GRANT/SET PASSWORD

(MDEV-34340) mariadb-backup immediately dumps core

(MDEV-29351) SIGSEGV when doing forward reference of item in select list

(MDEV-35144) CREATE TABLE ... LIKE uses current innodb_compression_default instead of the create value

(MDEV-35236) Assertion (mem_root->flags & 4) == 0 failed in safe_lexcstrdup_root

(MDEV-32022) ERROR 1054 (42S22): Unknown column 'X' in 'NEW' in trigger

(MDEV-35249) Assertion (mem_root->flags & 4) == 0 failed in convert_subq_to_jtbm

(MDEV-34447) Memory leakage is detected on running the test main.ps against the server 11.1

(MDEV-34833) Assertion failure in Item_float::do_build_clone (Item_static_float_func)

(MDEV-34776) Assertion failure in Item_string::do_build_clone

(MDEV-34636) SIGSEGV in ha_spider::update_create_info & SIGSEGV in my_hash_insert on ALTER

(MDEV-34376) Wrong data types when mixing an utf8 TEXT column and a short binary

(MDEV-33990) SHOW STATUS counts ER_CON_COUNT_ERROR as Connection_errors_internal

(MDEV-31636) Memory leak in Sys_var_gtid_binlog_state::do_check()

(MDEV-34869) ssl-cipher server system variable cannot configure both TLSv1.3 and TLSv1.2 ciphers at the same time

(MDEV-34589) Assertion !is_set() || (m_status == DA_EOF_BULK && is_bulk_op()) failed from mysql_admin_table on CHECK TABLE

(MDEV-34996) Buildbot MSAN options in buildbot rather than server

(MDEV-33035) Galera test case MDEV-16509 unstable

(MDEV-32996) galera.galera_var_ignore_apply_errors -> [ERROR] WSREP: Inconsistency detected

(MDEV-30307) KILL command issued inside a transaction is problematic for galera replication

(MDEV-26314) ST_EQUALS listed twice in information_schema.SQL_FUNCTIONS

(MDEV-35007) mroonga modifies source files during build

(MDEV-34993) Incorrect cardinality estimation causes poor query plan

(MDEV-34915) Out of order output in sys_vars.session_track_system_variables_basic in s390x builders

(MDEV-35116) InnoDB fails to set error index for HA_ERR_NULL_IN_SPATIAL

(MDEV-34659) SIGSEGV in __memcpy_evex_unaligned_erms from [Static_][Bb]inary_string::q_append on SELECT

(MDEV-30067) Assertion !error failed in ha_partition::delete_row on DELETE

(MDEV-34662) session_track_system_variables_basic test result (s390x only)

(MDEV-34533) ASAN error about stack overflow when writing record in Aria

(MDEV-35162) Error:

(MDEV-8578) Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION

(MDEV-34929) Innodb page compression is not working at windows

(MDEV-31888) galera.galera_wan, galera.galera_vote_rejoin_* fail

(MDEV-29260) Server crashes when running migration queries inside Docker on Windows

(MDEV-35253) innodb.xa_prepare_unlock_unmodified fails in UBSAN

(MDEV-35183) ADD FULLTEXT INDEX unnecessarily DROPS FTS COMMON TABLES

(MENT-2118) MENT-1555 fails on optimized builds due to debug_dbug use

(MDEV-34755) GCC -Wstringop-truncation due to safe_strcpy()

(MDEV-34921) MemorySanitizer reports errors for non-debug builds

(MDEV-31221) UBSAN runtime error: negation of -9223372036854775808 cannot be represented in type 'long long int' in my_strtoll10_utf32

(MDEV-31302) Assertion mon > 0 && mon < 13 failed in my_time_t sec_since_epoch(int, int, int, int, int, int)

(MDEV-32891) Assertion value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL failed in str_to_DDhhmmssff_internal

(MDEV-28386) UBSAN: runtime error: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in my_strntoull_8bit on SELECT ... OCT

(MDEV-25900) Assertion octets < 1024 failed in Binlog_type_info_fixed_string::Binlog_type_info_fixed_string OR Assertion field_length < 1024 failed in Field_string::save_field_metadata

(MDEV-33500) rpl.rpl_parallel_sbm can fail on slow machines, e.g., MSAN/Valgrind builders

(MDEV-34567) unit.my_apc always failing on FreeBSD-14

(MDEV-34864) SHOW INDEX FROM - SEQ_IN_INDEX - mysql-connector-net incompatibility

(MDEV-34825) FreeBSD fails to build under clang natively

(MDEV-34952) main.log_slow test failure on opensuse builder

(MDEV-33858) Assertion (mem_root->flags & 4) == 0 fails on 2nd execution of PS with -DWITH_PROTECT_STATEMENT_MEMROOT=ON

(MDEV-33897) Galera test failure on galera_3nodes.galera_gtid_consistency

(MDEV-33133) GCF-1060 test causes a server crash

(MDEV-34640) galera_var_ignore_apply_errors test freezes

(MDEV-34594) Assertion client_state.transaction().active() failed in int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type)

(MDEV-30686) With wsrep_sst_rsync , Node goes into endless loop when trying to establish connection to donor for IST

(MDEV-34823) Invalid arguments in ib_push_warning()

(MDEV-34579) sp-no-valgrind fails when server is compiled with valgrind

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

(MDEV-34785) Assertion failure in Item_func_or_sum::do_build_clone (Item_func_not_all)

(MDEV-34831) MDEV-34704 introduces a typo, --qick

(MENT-1403) plugins.server_audit2_client fails with an extra line in output

(MDEV-33091) PCRE2 headers aren't found on Solaris

(MDEV-34734) Windows build crashes (OpenSSL)

(MDEV-34714) perror-win test error on localized Windows

(MDEV-34078) Memory leak in InnoDB purge when the PRIMARY KEY is defined on 32 columns

(MDEV-34994) Reduce CPU load due to unnecessary accept() calls

(MDEV-34757) assertion of (mem_root->flags & 4) == 0 fails in 2nd ps execution with partition pruning

(MENT-2174) MW-402 galera test fails sporadically

(MDEV-34783) SIGSEGV on SELECT query

(MDEV-14231) MATCH() AGAINST( IN BOOLEAN MODE), results mismatch

(MENT-2133) backport MDEV-34483 "Backup may copy unnecessarily much log"

(MENT-2182) Cherry-pick MDEV-35470 - Internal temporary Aria tables writes blocks to disk at end of query