Release Notes for MariaDB Enterprise Server 10.2.38-12

ALTER TABLE fails to rename a column in InnoDB table and causes server to crash. InnoDB table is not accessible after restart. (MDEV-24763)

Table corruption ER_NO_SUCH_TABLE_IN_ENGINE or ER_CRASHED_ON_USAGE after ALTER on InnoDB table with foreign key. (MDEV-24532)

MariaDB Enterprise Backup deletes the current source file after a No space left on device error, before exiting. Only the incomplete target file is still available. (MDEV-25221)

Possible hang when KILL CONNECTION or KILL QUERY is used with MariaDB Enterprise Cluster and a multi-master setup. (MDEV-18874)

Possible memory corruption with MariaDB Enterprise Cluster when inserting values bigger than 4096 bytes into variable-length fields (BLOB, TEXT, VARCHAR, and related types). (MDEV-24978)

innodb_flush_method=O_DIRECT fails on compressed tables. (MDEV-25121)

Server crashes in check_grant upon invoking function with userstat enabled. (MDEV-25242)

MariaDB Client crashes when --default-character-set is set and --character-sets-dir is undefined. (MDEV-24879)

Possible Server crash when dropping a table. Only seen when using a table space per table and if the tablespace size is increased at the time of the drop. (MDEV-20648)

Possible server hang with InnoDB and indexed virtual columns after an error with UPDATE, INSERT, REPLACE on virtual columns. (MDEV-24786)

MariaDB Enterprise Cluster conflict resolution issues. (MDEV-24923)

Index count mismatch due to aborted FULLTEXT INDEX (MDEV-25200)

MariaDB Enterprise Cluster node crashes when inserting a row into a table that contains a virtual column and does not have a primary key. (MDEV-25047)

Server crashes when InnoDB fails to add a new index on a new virtual column and a concurrent connection executes a query that accesses the freed virtual column. (MDEV-24971)

EXISTS subquery with correlation in ON expression crashes. (MDEV-25407)

Server crashes in row_undo_mod_clust_low upon rollback of read-only transaction. (MDEV-25457)

Server crashes on the second execution of a stored procedure when the stored procedure uses an invalid multi-table UPDATE statement to update a view. (MDEV-24823)

InnoDB startup hangs when a recovered transaction exists for the mysql.innodb_index_stats or mysql.innodb_table_stats system tables and a DDL transaction needs to be rolled back. (MDEV-25503)

Server crashes when InnoDB tries to fetch data from table containing a FULLTEXT INDEX and the table's tablespace was discarded. (MDEV-25536)

Server crashes on SHOW TABLES when a WHERE condition references a derived table. (MDEV-21603)

Potential hang in InnoDB purge when virtual indexed columns exist. (MENT-1203)

After DROP INDEX or CREATE INDEX, change buffer entries for secondary indexes are lost on InnoDB restart. (MENT-1217)

SUM column from a derived table returns invalid values. (MDEV-23291)

CAST('0e1111111111' AS DECIMAL(38,0)) returns an incorrect result. (MDEV-24790)

Incorrect behavior of SET STATEMENT when it is executed as a prepared statement. (MDEV-24860)

Query returns a ER_BAD_FIELD_ERROR error when a subquery contains a JOIN with an ON clause that references an outer column. (MDEV-25002)

Query returns a ER_BAD_FIELD_ERROR error when a Common Table Expression (CTE) contains a UNION (MDEV-24597)

Query returns wrong result when the MIN() or MAX() aggregate functions are used and the aggregated column is indexed. (MDEV-25112)

Wrong result (extra rows and wrong values) with incremental block nested loop hash. (MDEV-21104)

Query returns wrong results when a JOIN is evaluated using the Block Nested Loop Hash (BLNH) optimization with a compound index. (MDEV-24767)

Server fails to start using mysqld_multi with mysqld_safe options. (MDEV-21039)

Duplicate key may be generated during MariaDB Enterprise Cluster configuration change. (MDEV-24853)

State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Backup fails when the --log-bin option was set on the command-line with no value at server startup. (MDEV-24903)

Race condition between persistent statistics and RENAME TABLE or TRUNCATE (MDEV-25051)

Race condition between ANALYZE TABLE and STATS_AUTO_RECALC (MDEV-10682)

Incorrect message about field length is written to the error log when CHECK TABLE is executed on an InnoDB table. (MDEV-24748)

No error is returned when the optimizer removes a redundant part of a subquery that contains an unknown table alias. For example, if the optimizer removes a redundant GROUP BY clause from an IN() subquery, unknown table aliases in the redundant part are ignored. (MDEV-23449)

Selectivity shown with EXPLAIN in field "filter" is incorrect for BIT columns. (MDEV-22583)

Histogram statistics are used even with optimizer_use_condition_selectivity=3 (MDEV-19474)

EXPLAIN shows nonsensical value for key_len with type=index (MDEV-11172)

SSL connection fails when server and client certs are signed by same CA. (MDEV-23740)

Wrong function name in error messages upon ST_GeomFromGeoJSON call. (MDEV-25272)

MariaDB Enterprise Backup fails --prepare on large backup. (MDEV-24197)

State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Backup fails when the password for the backup user is set via the MYSQL_PWD environment variable. (MDEV-25321)

State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Backup fails when the --innodb option was set on the command-line at server startup. (MDEV-25328)

An extra warning is returned when the EXPLAIN EXTENDED statement is executed in a prepared statement. (MDEV-25108)

Complex query in stored procedure returns wrong results. (MDEV-25182)

ALTER TABLE wrongly checks for field's default value if AFTER is used. (MDEV-25403)

Incorrect name resolution for subqueries in ON expressions. (MDEV-25362)

When FLUSH LOGS is executed, a race condition between InnoDB group commit and binary log rotation causes the old binary log file to become obsolete before the InnoDB group commit has been written to it. (MDEV-24526)

MariaDB Enterprise Backup logs an error instead of a warning when it reads an invalid log block checksum during a --backup. (MDEV-25456)

Rows are wrongly omitted when an InnoDB index is read using Multiversion Concurrency Control (MVCC). (MDEV-25459)

SELECT aborts after failed REPLACE into table with virtual column. (MDEV-24583)

InnoDB fails to fetch index type when index mismatch happens. (MDEV-22928)

MariaDB Enterprise Cluster silently enables InnoDB Monitor output and never disables it when a wsrep slave thread tries to perform a brute-force (BF) kill, but fails due to a long lock wait. (MDEV-25319)

RENAME TABLE causes "Ignoring data file ... with space ID xxxx, since the redo log references ... with space ID xxxx." for MariaDB Enterprise Backup. (MDEV-25568)

The Replication Heartbeat binary log event (Heartbeat_log_event) uses 4 bytes to store the log position within the current binary log file, so the log position overflows when the binary log file size exceeds 4 GB. (MDEV-16146)

InnoDB spatial indexes miss large geometry fields. (MENT-1205)

Table alias from previous statement interferes with later commands. (MENT-1200)

MariaDB Enterprise Cluster fails to replicate SET PASSWORD statement when strict_password_validation is enabled. (MDEV-25258)

Missing libsepol dependency on SLES 12 and SLES 15. (MENT-1163)

caching_sha2_password.so isn't included in Debian packages. (MDEV-24728)

Minor version upgrade does not perform server restart. (MDEV-25240)