MariaDB 10.10.1 RC and 10.9.2 GA Release Highlights and Bug Fixes

MariaDB 10.10.1 RC and 10.9.2 GA have been released, delivering a short‑term support series with numerous bug fixes and improvements for InnoDB, replication, Galera clustering, the optimizer and other core components, enhancing stability and performance for database users.

InnoDB

Fix for InnoDB corruption caused by missing file locks (MDEV-28495).

FULLTEXT search with apostrophes and forced words (MDEV-20797).

ALTER TABLE IMPORT TABLESPACE no longer corrupts encrypted tables (MDEV-28779).

Corrected ALTER TABLE erroneous results (MDEV-26294).

Crash‑recovery fixes (MDEV-28668, MDEV-28731).

DDL crash‑recovery fixes (MDEV-28752, MDEV-28802, MDEV-28864, MDEV-28870, MDEV-28923, MDEV-28977).

Prevention of data‑corrupting crashes (MDEV-13542, MDEV-18519, MDEV-21098, MDEV-22388, MDEV-28457, MDEV-28950).

Batch load error fixes (MDEV-28242, MDEV-28679).

Performance fixes (MDEV-28708, MDEV-28766).

Removal of innodb_version (MDEV-28554).

Deprecation of innodb_prefix_index_cluster_optimization (MDEV-28540).

Removal of useless output in SHOW ENGINE INNODB STATUS (MDEV-28542).

Replication

ER_SLAVE_INCIDENT now appears on the slave for visibility via SHOW SLAVE STATUS (MDEV-21087).

INCIDENT_EVENT is no longer binlogged when the recorded transaction can be safely rolled back (MDEV-21443).

Row‑format events for sequences now correspond to binlog_row_image (MDEV-28487).

Removed possible cause for pending FLUSH BINARY LOGS (MDEV-28948).

Fixed out‑of‑order GTID error in semi‑synchronous loop (MDEV-28609).

Added global.slave_max_statement_time to limit execution time per query (MDEV-27161).

MASTER_USE_GTID=Current_Pos deprecated in CHANGE MASTER to support MASTER_DEMOTE_TO_SLAVE (MDEV-20122).

Default values for MASTER_USE_GTID in CHANGE MASTER TO and RESET SLAVE updated for GTID‑based replication compatibility (MDEV-19801).

Galera

Write/update possible with read_only=ON without SUPER privilege (MDEV-28546).

Node crash with signal 6 when transport endpoint not connected (MDEV-25068).

Galera 4 cannot correctly report wsrep_incoming_addresses (MDEV-20627).

Galera now replicates changes to nextval() in sequences with INCREMENT <> 0, at least for InnoDB NOCACHE sequences (MDEV-27862).

Added OpenSSL 3.0 support to Galera (MDEV-25949).

Implemented method to whitelist IPs for SST/IST requests (MDEV-27246).

Optimizer

Server crash in JOIN_CACHE::free or copy_fields (MDEV-23809). Queries using DISTINCT with constant functions like COLLATION() may crash; COLLATION() is treated as constant even when its argument is not.

Crash when using ANY predicate with redundant subqueries in GROUP BY (MDEV-29139). Example query pattern shown below.

Server SEGV on INSERT … SELECT with aggregate or window functions (MDEV-26427). Certain INSERT … SELECT forms may cause crashes.

restore_prev_nj_state() does not correctly update cur_sj_inner_tables (MDEV-28749). Subquery semi‑join optimization may miss LooseScan or FirstMatch strategies.

Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246). Partition pruning not applied for multi‑table UPDATE/DELETE.

Range optimizer regression for key IN (const, …) (MDEV-25020). Observed in MariaDB 10.5.9+; related to optimizer_max_sel_arg_weight.

Incorrect results when combining NOT_NULL_RANGE_SCAN with tables (MDEV-28858). Enabling optimizer_switch='not_null_range_scan=on' may produce wrong results.

Assertion failure tmp >= 0 in best_access_path (MDEV-28882). Occurs with histogram_type=JSON_HB and very narrow ranges near histogram ends.

General

Crash in JSON_EXTRACT (MDEV-29188).

ALTER TABLE ALGORITHM=NOCOPY ineffective after upgrade (MDEV-28727).

Server crash when CREATE VIEW has unknown column in ON condition (MDEV-29088).

password_reuse_check plugin mixes usernames and passwords (MDEV-28838).

MariaDB 10.10 will be the last version for Debian 10 "Buster" on ppc64el per deprecation policy.

Code Examples

... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...

table.keyXpartY [NOT] IN (...)