arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

MariaDB 10.8.4 Release Notes

The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Nowarrow-up-right

Download 10.8.4arrow-up-right | Release Notes | Changelog | Overview of 10.8

Release date: 15 Aug 2022

MariaDB 10.8 is the current short-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.7 with several entirely new features.

MariaDB 10.8.4 is a Stable (GA) release.

For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

Thanks, and enjoy MariaDB!

hashtag
Notable Items

hashtag
InnoDB

  • InnoDB corruption due to lack of file locking ()

  • FULLTEXT search with apostrophe, and mandatory words ()

  • ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()

hashtag
Replication

  • is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()

  • ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()

  • INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()

hashtag
Galera

  • updated to 26.4.12

  • Possible to write/update with read_only=ON and not a SUPER privilege ()

  • Node crashes with Transport endpoint is not connected mysqld got signal 6 ()

hashtag
Optimizer

  • Server crash in JOIN_CACHE::free or in copy_fields ()

    • Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.

  • Crash when using ANY predicand with redundant subquery in GROUP BY clause ()

  • MariaDB Server SEGV on INSERT .. SELECT ()

    • Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.

  • restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly ()

  • Wrong result with table elimination combined with not_null_range_scan ()

    • If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.

  • Assertion `tmp >= 0' failed in best_access_path ()

hashtag
Spider

  • and have been deprecated (, )

  • Spider's high-availability feature has been deprecated ()

hashtag
JSON

  • : extract document fragment into JSON column ()

hashtag
CONNECT

  • now supports with ()

hashtag
General

  • now also has a session scope, not only global ()

  • New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.

  • Crash in ()

hashtag
Security

  • Fixes for the following :

hashtag
Changelog

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

hashtag
Contributors

For a full list of contributors to , see the .

circle-info

Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

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

ALTER TABLE wrong-result fix ()
  • Crash recovery fixes (, )

  • DDL crash recovery fixes (, , , , , )

  • Avoid crashes on corrupted data (, , , , , )

  • Bulk load bug fixes (, )

  • Performance fixes (, )

  • sequences related row-format events are made to correspond to binlog_row_image ()
  • Possible reason of FLUSH BINARY LOGS hang is eliminated ()

  • Fix out-of-order gtid error in the circular semisync setup ()

  • Galera4 not able to report proper wsrep_incoming_addresses ()
  • Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB ()

  • Add support for OpenSSL 3.0 in Galera ()

  • A query with a subuquery in this form could cause a crash:

    Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.

  • Optimizer uses all partitions after upgrade to 10.3 ()

    • For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.

  • Range optimizer regression for key IN (const, ....) ()

    • The issue can be observed on and later versions which have the fix for . That fix introduceds optimizer_max_sel_arg_weight.

    • If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:

  • If one uses histogram_type=JSON_HB, has collected a histogram of that type and runs a query that selects a very narrow range near histogram end, they can hit an assertion in the optimizer due to rounding errors in the histogram causing negative selectivity.

    ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade ()

  • Server crash upon CREATE VIEW with unknown column in ON condition ()

  • password_reuse_check plugin mixes username and password ()

  • As per the , this will be the last release of for Debian 10 "Buster" for ppc64el

  • Repositories for Ubuntu 22.04 and RHEL/Rocky 9 have been added in this release

  • ... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
    table.keyXpartY [NOT] IN ( ... )
    MDEV-28495arrow-up-right
    MDEV-20797arrow-up-right
    MDEV-28779arrow-up-right
    MDEV-29078arrow-up-right
    MDEV-21087arrow-up-right
    MDEV-21443arrow-up-right
    Galeraarrow-up-right
    MDEV-28546arrow-up-right
    MDEV-25068arrow-up-right
    MDEV-23809arrow-up-right
    MDEV-29139arrow-up-right
    MDEV-26427arrow-up-right
    MDEV-28749arrow-up-right
    MDEV-28858arrow-up-right
    MDEV-28882arrow-up-right
    spider_init_sql_alloc_sizearrow-up-right
    spider_buffer_sizearrow-up-right
    MDEV-27926arrow-up-right
    MDEV-28560arrow-up-right
    MDEV-28479arrow-up-right
    MDEV-25875arrow-up-right
    CONNECT Enginearrow-up-right
    Mysql Table typearrow-up-right
    MDEV-27766arrow-up-right
    MDEV-29225arrow-up-right
    MDEV-29188arrow-up-right
    CVE-2023-5157arrow-up-right
    CVE-2022-32082arrow-up-right
    MariaDB 10.8.4
    changelog
    MariaDB 10.8.4
    MariaDB Foundation release announcementarrow-up-right
    subscribingarrow-up-right
    MDEV-26294arrow-up-right
    MDEV-28668arrow-up-right
    MDEV-28731arrow-up-right
    MDEV-28752arrow-up-right
    MDEV-28802arrow-up-right
    MDEV-28864arrow-up-right
    MDEV-28870arrow-up-right
    MDEV-28923arrow-up-right
    MDEV-28977arrow-up-right
    MDEV-13542arrow-up-right
    MDEV-18519arrow-up-right
    MDEV-21098arrow-up-right
    MDEV-22388arrow-up-right
    MDEV-28457arrow-up-right
    MDEV-28950arrow-up-right
    MDEV-28242arrow-up-right
    MDEV-28679arrow-up-right
    MDEV-28708arrow-up-right
    MDEV-28766arrow-up-right
    MDEV-28487arrow-up-right
    MDEV-28948arrow-up-right
    MDEV-28609arrow-up-right
    MDEV-20627arrow-up-right
    MDEV-27862arrow-up-right
    MDEV-25949arrow-up-right
    MDEV-28246arrow-up-right
    MDEV-25020arrow-up-right
    MariaDB 10.5.9
    MDEV-9750arrow-up-right
    MDEV-28727arrow-up-right
    MDEV-29088arrow-up-right
    MDEV-28838arrow-up-right
    MariaDB Deprecation Policy
    MariaDB 10.8
    CVE-2022-32089arrow-up-right
    CVE-2022-32081arrow-up-right
    CVE-2018-25032arrow-up-right
    CVE-2022-32091arrow-up-right
    CVE-2022-38791arrow-up-right
    CVE-2022-32084arrow-up-right
    spinner
    Distributions which Include MariaDB
    explicit_defaults_for_timestamp
    JSON_TABLE
    INSERT IGNORE
    explicit_defaults_for_timestamp
    mariadb client
    JSON_EXTRACT
    security vulnerabilities