MariaDB 10.9.1 Changelog

The most recent release of MariaDB 10.9 is:MariaDB 10.9.8 Stable (GA) Download Now

Download 10.9.1Release NotesChangelogOverview of 10.9

Release date: 20 May 2022

For the highlights of this release, see the release notes.

The revision number links will take you to the revision's page on GitHub. On GitHub you can view more details of the revision and view diffs of the code modified in that revision.

• Changes from 10.9.0 are also included in this changelog

• Includes all fixes from

• Merge 2022-05-18 15:04:50 +0200 - Merge branch '10.8' into 10.9

• 2022-05-14 20:24:09 +0300

  • Correct misplaced parentheses in an assertion

• 2022-05-14 13:02:51 +0300

  • fixup: GCC 12 -Wmaybe-uninitialized, -Wunused-but-set-variable

• 2022-05-13 17:02:12 +0200

  • Versions fix

• 2022-05-07 19:10:59 +0300

  • Optimizer trace: Make ref_optimizer_key_uses[*] show the index name

• 2022-05-12 10:55:18 +0400

  • SIGSEGV in Lex_charset_collation_st::find_bin_collation

• 2022-05-10 08:22:21 +0200

  • : Hashicorp: Debian packaging is broken

• 2022-05-06 15:01:08 +0200

  • : Hashicorp: Cannot migrate hexadecimal keys from file key management

• 2022-04-29 18:01:34 +0200

  • Hashicorp plugin: typo fixed

• 2022-04-29 06:57:18 +0200

  • : Hashicorp: refactoring to wrap static variables into a class

• 2022-04-28 15:06:16 +0200

  • : Hashicorp: Cache variables claim to be dynamic but changes are ignored

• 2022-04-28 14:56:41 +0200

  • : Hashicorp: Key caching doesn't appear to be working

• 2022-04-19 04:34:48 +0200

  • : Hashicorp: checking that kv storage is created with version 2+

• 2022-04-28 13:33:23 +0200

  • : Checking for mandatory "/v1/" prefix in the URL

• 2022-04-28 13:10:39 +0200

  • : Hashicorp: Key ID is not indicated in the log record

• 2022-04-18 16:44:28 +0200

  • : Hashicorp: ASAN heap-use-after-free in get_version()

• 2020-07-13 19:12:00 +0200

  • : Plugin implementation for the Hashicorp Vault KMS

• 2022-05-06 10:45:18 +0300

  • Auto-create breaks replication when triggering event was not replicated

• 2022-05-06 10:45:17 +0300

  • Auto-create new partition for system versioned tables with history partitioned by INTERVAL/LIMIT

• 2022-05-06 10:45:17 +0300

  • Change of SYSTEM_TIME partitioning options is not possible without data copy

• 2022-05-06 10:45:17 +0300

  • cleanup: log_current_statement and OPTION_KEEP_LOG

• 2022-05-06 12:00:01 +1000

  • Deb: dh_missing --fail-missing - columnstore

• 2022-05-06 10:25:25 +1000

  • Deb: dh_missing --fail-missing/ man3 pages

• 2022-05-02 22:07:58 -0700

  • Deb: Use --fail-missing and ensure the not-installed list is up-to-date

• 2022-04-30 23:27:39 -0700

  • Deb: Finalize the version less Debian package transition

• 2022-04-30 23:14:19 -0700

  • Deb: Don't Conflicts/Replaces with a 10.9 provided by the same package

• 2022-05-02 20:31:15 -0700

  • Deb: Clean away Buster to Bookworm upgrade tests in Salsa-CI

• 2022-04-30 23:14:59 -0700

  • Deb: Remove from Salsa-CI buster-backports as it does not have libfmt 7+

• 2022-05-04 00:23:27 -0700

  • Deb: Run wrap-and-sort -av

• 2022-05-02 09:21:19 +0300

  • fixup: Tests depend on PLUGIN_PERFSCHEMA

• 2022-05-02 09:14:32 +0300

  • After-merge fixes

• 2022-04-29 11:49:42 +0300

  • Fix comment.

• Merge 2022-04-29 11:09:52 +0300 - Merge , into 10.9

• 2022-04-26 23:29:29 +0300

  • : Server crashes in Expression_cache_tracker::fetch_current_stats

• 2022-04-04 12:32:22 +0300

  • : Server crashes upon SHOW ANALYZE/EXPLAIN FORMAT=JSON

• 2022-03-27 11:58:27 +0700

  • Server crashes in Explain_aggr_filesort::print_json_members

• 2022-02-16 13:03:46 +0700

  • Add explicit indication of SHOW EXPLAIN/ANALYZE.

• 2022-02-02 19:44:43 +0700

  • Add support of FORMAT=JSON for SHOW ANALYZE

• 2021-12-24 17:27:03 +0300

  • Implement SHOW ANALYZE command

• 2022-01-11 20:25:11 +0300

  • Add EXPLAIN [FORMAT=JSON] FOR CONNECTION syntax support

• 2022-04-28 10:06:47 -0600

  • : rpl.rpl_mysqlbinlog_slave_consistency fails intermittently on tables comparison

• Merge 2022-04-28 15:54:03 +0300 - Merge 10.8 into 10.9

• 2022-04-18 22:30:20 +0530

  • : Assertion `cur_step->type & JSON_PATH_KEY' failed in json_find_path

• 2022-04-19 21:43:31 +0530

  • : Test failing on buildbot with UBSAN

• 2022-04-18 15:31:36 +0530

  • : Server crashes in json_path_parts_compare

• 2022-04-11 11:32:26 +0300

  • : Remove version suffix from Debian packages

• 2022-03-09 20:50:49 +0530

  • : No warnings if server starts with "--old" Analysis: When --old option is used, the corresponding --old-mode variables are set but warning is not given. Fix: Use sql_print_warning() to give warning.

• 2021-08-13 15:49:16 +0530

  • : Merge "old" SQL variable to "old_mode" sql variable

• 2022-02-03 08:31:05 -0700

  • : Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for mysqlbinlog

• 2022-04-15 01:28:33 +0530

  • Fixing merge conflicts for 10.9 json task and related bugs

• 2022-03-21 12:43:17 +0530

  • : JSON_EXTRACT has inconsistent behavior with '0' value in json path (when range is used)

• 2022-03-21 21:19:10 +0530

  • : JSON_EXISTS returns always 1 if it is used range notation for json path Analysis: When searching for the given path in json string, if the current step is of array range type, then path was considered reached which meant path exists. So output was always true. The end indexes of range were not evaluated. Fix: If the current step type for a path is array range, then check if the value array_counter[] is in range of n_item and n_item_end. If it is, then path exists. Only then return true. If the range criteria is never met then return false.

• 2022-03-18 18:12:59 +0530

  • vcol.wrong_arena failing on buildbot when current date is '2022-03-17'

• 2022-03-05 01:03:49 +0530

  • : Implement range notation for json path

• 2022-03-01 16:14:36 +0530

  • : Unexpected behavior with negative zero (-0) in JSON Path

• 2021-11-22 22:59:30 +0530

  • : Support JSON Path negative index

• Merge 2022-04-13 13:39:00 +0300 - Merge 10.8 into 10.9

• 2022-04-13 15:05:19 +1000

  • : rocksdb_log_dir test postfix

• 2022-01-19 23:40:41 +0000

  • : Create a new MyRocks parameter rocksdb_log_dir

• 2022-04-12 11:33:52 +0300

  • Added scripts/wsrep_sst_backup to .gitignore

• 2022-04-12 11:32:02 +0300

  • mysqldump --order-by-size

• 2022-04-07 23:49:19 -0700

  • Spider: remove #ifdef HANDLER_HAS_NEED_INFO_FOR_AUTO_INC

• Merge 2022-04-06 13:33:33 +0300 - Merge 10.8 into 10.9

• Merge 2022-04-06 14:33:27 +1000 - Merge branch 10.8 into 10.9

• 2022-03-31 22:55:11 +0900

  • Spider: Remove unnecessary files for Autotools

• 2022-02-10 16:51:49 +0900

  • Spider: remove #WITH_PARTITION_STORAGE_ENGINE

• 2022-01-26 03:02:45 +0530

  • : Add a THD* argument to Item_func_or_sum::fix_length_and_dec()

• 2022-03-03 14:40:55 +0530

  • : Incorrect behavior of JSON_OVERLAPS() on warning

• 2022-01-30 15:45:25 +0530

  • : Implement JSON_OVERLAPS()

• Merge 2022-03-30 09:41:14 +0300 - Merge 10.8 into 10.9

• 2022-02-09 21:21:39 +0400

  • Remove Lex::charset

• 2022-02-09 17:59:38 +0400

  • Reduce the size of Lex_length_and_dec_st from 16 to 8

• 2022-03-22 04:40:04 +0100

  • post-fix: fixes for SST scripts

• 2022-03-16 10:14:48 +0200

  • Fix compile error.

• 2022-02-17 17:19:07 +0200

  • : Implement progress reporting by mariadb-backup SST script

• 2022-02-17 17:14:04 +0200

  • : JSON file interface to wsrep node state.

• 2022-02-10 08:51:48 +0200

  • Small fixes Add new requirement for pv tool for debian and rpm Fix one test result difference. Set message about missing progress reporting tool pv as info.

• 2021-12-18 18:30:24 +0200

  • : Implement progress reporting by mariadb-backup SST script

• 2021-12-16 13:46:37 +0200

  • : Support for progress reporting from SST scripts.

• 2021-09-05 17:07:05 +0300

  • : JSON file interface to wsrep node state.

• 2022-03-16 09:12:03 +0200

  • Update wsrep-lib submodule

• Merge 2022-03-18 11:14:48 +0100 - Merge branch '10.8' into 10.9

• Merge 2022-03-17 14:38:35 +0100 - Merge branch '10.8' into 10.9

• Merge 2022-03-17 09:59:37 +0200 - Merge 10.8 into 10.9

• Merge 2022-03-16 09:14:11 +0200 - Merge 10.8 into 10.9

• 2022-03-16 08:41:56 +0200

  • fixup: Use log_sys.get_block_size()

• Merge 2022-03-15 18:26:29 +0200 - Merge 10.8 into 10.9

• Merge 2022-03-11 16:18:39 +0200 - Merge 10.8 into 10.9

• 2022-03-11 11:10:09 +0200

  • : Fix a race condition, and pacify MemorySanitizer

• Merge 2022-03-11 11:07:49 +0200 - Merge 10.8 into 10.9

• 2022-03-10 21:02:41 +0900

  • Spider: remove #ifdef SPIDER_SQL_CACHE_IS_IN_LEX

• 2022-03-10 08:39:27 +0000

  • Spider: remove #ifdef SPIDER_USE_CONST_ITEM_FOR_STRING_INT_REAL_DECIMAL_DATE_ITEM

• Merge 2022-03-08 10:36:22 +0200 - Merge 10.8 into 10.9

• 2022-03-04 13:19:52 +0200

  • Flag innodb_change_buffering as PLUGIN_VAR_DEPRECATED

• Merge 2022-03-03 13:03:17 +0200 - Merge 10.8 into 10.9

• 2022-03-02 16:53:04 +0200

  • Allow SET GLOBAL innodb_log_file_size

• Merge 2022-03-01 12:47:18 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-25 16:32:33 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-23 17:01:11 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-23 10:20:58 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-22 19:02:15 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-18 08:28:49 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-15 19:28:58 +0200 - Merge 10.8 into 10.9

• Merge 2022-02-14 19:51:23 +0200 - Merge 10.8 into 10.9

• 2022-02-14 10:29:18 +0200

  • Deprecate the parameter innodb_change_buffering

• Merge 2022-02-14 09:49:05 +0200 - Merge 10.8 into 10.9

• 2022-02-11 17:47:33 +0900

  • Spider: remove #ifdef SPIDER_SUPPORT_CREATE_OR_REPLACE_TABLE

• 2022-02-11 14:58:20 +0900

  • Spider: remove #ifdef SPIDER_HANDLER_START_BULK_INSERT_HAS_FLAGS (#2012)

• 2022-02-10 15:36:44 +0900

  • Spider: Remove dead code related to Oracle OCI

• 2022-02-10 14:47:55 +0900

  • fixup: Delete constants used nowhere

• 2022-01-28 16:20:29 +0900

  • Spider: remove #ifdef HANDLER_HAS_DIRECT_UPDATE_ROWS_WITH_HS

• 2022-01-28 16:19:06 +0900

  • Spider: remove #if defined(PARTITION_HAS_GET_CHILD_HANDLERS)

• 2022-01-28 16:14:31 +0900

  • Spider: remove #ifdef SPIDER_HANDLER_SUPPORT_MULTIPLE_KEY_PARTS

• 2022-01-28 16:13:12 +0900

  • Spider: remove #ifdef SPIDER_HAS_DISCOVER_TABLE_STRUCTURE

• 2022-01-28 16:11:24 +0900

  • Spider: remove #ifdef MARIADB_BASE_VERSION

• 2022-01-28 16:09:48 +0900

  • Spider: remove dead code in #ifdef HA_HAS_CHECKSUM_EXTENDED

• 2022-01-28 16:08:01 +0900

  • Spider: remove #ifdef SPIDER_HAS_GROUP_BY_HANDLER

• 2022-01-28 16:06:27 +0900

  • Spider: remove in #ifdef HASH_UPDATE_WITH_HASH_VALUE

• 2022-01-28 16:05:09 +0900

  • Spider: remove #ifdef HANDLER_HAS_DIRECT_UPDATE_ROWS

• 2022-01-28 16:03:46 +0900

  • Spider: remove #ifdef SPIDER_HAS_HASH_VALUE_TYPE

• 2022-01-28 16:02:54 +0900

  • Spider: remove #ifdef HA_MRR_USE_DEFAULT_IMPL

• 2022-01-28 16:01:17 +0900

  • Spider: remove #ifdef HANDLER_HAS_DIRECT_AGGREGATE

• 2022-01-28 15:57:07 +0900

  • Spider: remove #ifdef HA_CAN_BULK_ACCESS

• 2022-01-28 15:55:22 +0900

  • Spider: remove #ifdef WITHOUT_SPIDER_BG_SEARCH

• 2022-01-28 01:03:06 +0900

  • Spider: remove #if MYSQL_VERSION_ID < ${VERSION}

• 2022-01-28 00:06:09 +0900

  • Spider: remove #if defined(MARIADB_BASE_VERSION) && MYSQL_VERSION_ID >= ${VERSION}

• Merge 2022-02-09 09:17:30 +0100 - Merge branch '10.8' into 10.9

• 2022-02-08 19:25:42 +0100

  • 10.9 branch