MariaDB 10.2.27 Changelog

Download Release Notes Changelog Overview of 10.2

Release date: 11 Sep 2019

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.

• Includes all fixes from MariaDB 10.1.41
• Revision #f9f968557f 2019-09-08 16:21:48 +0300
  • List of unstable tests for 10.2.27 release
• Revision #8750df43ab 2019-09-07 07:44:54 +0400
  • MDEV-20517 Assertion `!is_expensive()' failed in Item::value_depends_on_sql_mode_const_item
• Revision #39e5b76ef1 2019-09-06 14:42:46 +0200
  • use a shorter name for sources in debuginfo rpms
• Revision #5a9e2b77d4 2019-09-06 14:36:12 +0200
  • MDEV-18156 Assertion `0' failed or `btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with PAD_CHAR_TO_FULL_LENGTH
• Revision #2480f6b7ff 2019-09-06 14:08:46 +0200
  • don't run RocksDB suites by default
• Revision #292e2649d4 2019-09-06 12:47:48 +0300
  • MDEV-12121: Avoid unused variable
• Revision #16e9943d89 2019-09-04 10:31:40 +0300
  • MDEV-20421: big_innodb_log reliably fails on buildbot Windows
• Revision #41e351f608 2019-09-05 17:43:13 +0300
  • MDEV-20490: rocksdb.ttl_primary_read_filtering fails in BB
• Revision #f605ce08b5 2019-09-04 14:20:37 +0200
  • more tests for DEFAULT and DEFAULT(column) in INSERT
• Revision #8dca4cf53f 2019-09-04 14:02:01 +0200
  • MDEV-20403 Assertion `0' or Assertion `btr_validate_index(index, 0)' failed in row_upd_sec_index_entry or error code 126: Index is corrupted upon UPDATE with TIMESTAMP..ON UPDATE
• Revision #53ec9047c9 2019-07-27 19:57:46 +0530
  • MDEV-20137 rpl.mdev_17588 fails in buildbot with "Table doesn't exist"
• Revision #01e455dbb8 2019-09-04 01:59:35 +0300
  • Fix of query cache bug in Aria
• Revision #dae1b3b04c 2019-09-03 13:04:05 +0300
  • MDEV-15326: Backport trx_t::is_referenced()
• Revision #b07beff894 2019-09-03 12:31:37 +0300
  • MDEV-15326: InnoDB: Failing assertion: !other_lock
• Revision #7c79c12784 2019-09-02 14:00:53 +0300
  • MDEV-15326 preparation: Remove trx_sys_t::n_prepared_trx
• Revision #154bd0950f 2019-09-03 11:23:57 +0300
  • MDEV-15326 preparation: Test slow shutdown after XA PREPARE
• Revision #b2775ae855 2019-09-02 12:31:29 +0300
  • MVCC::view_close(): Correct comments
• Revision #cbb85f0d21 2019-09-04 08:36:52 +0300
  • Disable galera.galera_var_node_address test case.
• Revision #6ee7a9a438 2019-09-03 11:41:35 +0200
  • C/C
• Revision #c7c481f4d9 2019-09-02 14:10:20 +0200
  • MDEV-20403 Assertion `0' or Assertion `btr_validate_index(index, 0)' failed in row_upd_sec_index_entry or error code 126: Index is corrupted upon UPDATE with TIMESTAMP..ON UPDATE
• Revision #3789692d17 2019-09-02 14:14:57 +0200
  • don't compare unassigned columns
• Revision #17ab02f4b0 2019-09-02 10:53:46 +0200
  • cleanup: on update default now
• Revision #ef00ac4c86 2019-08-29 12:35:19 +0400
  • MDEV-18156 Assertion `0' failed or `btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with PAD_CHAR_TO_FULL_LENGTH
• Revision #dc719597ee 2019-08-26 15:28:32 +0400
  • MDEV-18156 Assertion `0' failed or `btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with PAD_CHAR_TO_FULL_LENGTH
• Revision #0d66358220 2019-09-02 17:18:04 +0300
  • Disabled test in 32bit that uses too much memory or cpu
• Revision #9cba6c5aa3 2019-08-30 16:06:54 +0300
  • Updated mtr files to support different compiled in options
• Revision #b23b3a5fb6 2019-09-01 15:13:22 +0300
  • Fixed some compiler warnings
• Revision #b0916141c7 2019-08-30 18:04:15 +0300
  • embedded client now writes errors to stderr during init_embedded_server
• Revision #d558981e2c 2019-08-30 14:38:16 +0300
  • Remove test that where only applicable for MySQL
• Revision #2d85714448 2019-08-30 16:07:26 +0300
  • Updated BUILD/SETUP from MariaDB 10.5
• Revision #d5a11a1f02 2019-09-01 13:27:32 +0200
  • C/C
• Merge Revision #14149d6c33 2019-08-30 16:52:43 +0200 - Merge remote-tracking branch 'connect/10.2' into 10.2
• Revision #6c593cd358 2019-08-22 23:34:42 +0200
  • Typo
• Revision #c0f9042500 2019-08-19 18:06:34 +0200
  • Some small changes. Modify tracing to use htrc to be compatible with old versions when this code is used to make an EOM module.
• Revision #4d93c7f3b0 2019-08-17 16:58:58 +0200
  • In CONNECT version 1.6.10 NOSQL facility is enhanced by a new way to retrieve NOSQL data. In addition to files and Mongo collections, JSON as well as XML and CSV data can be retrieved from the net as answers from REST queries. Because it uses and external package (cpprestsdk) this is currently available only to MariaDB servers compiled from source.
• Revision #d302cb3534 2019-07-31 11:17:59 +0200
  • Typo
• Revision #e4797a991f 2019-07-30 22:45:04 +0200
  • In CONNECT version 1.6.10 NOSQL facility is enhanced by a new way to retrieve NOSQL data. In addition to files and Mongo collections, JSON as well as XML and CSV data can be retrieved from the net as answers from REST queries. Because it uses and external package (cpprestsdk) this is currently available only to MariaDB servers compiled from source.
• Revision #1688a22612 2019-08-30 14:13:00 +0300
  • MDEV-18384: rocksdb.index_merge_rocksdb2 test fails
• Revision #5e9b34191e 2019-08-29 08:21:54 +0300
  • Clean up innodb.innodb-read-view
• Revision #2842ae03bc 2019-08-28 15:27:35 +0300
  • Remove a bogus comment
• Merge Revision #5f35e103ee 2019-08-28 15:23:21 +0300 - Merge 10.1 into 10.2
• Revision #4ba20e0a14 2019-08-28 04:49:01 +0200
  • Improved handling of subdirectories in the xtrabackup-v2 SST scripts (similar to MDEV-18863) for more predictable test results (related to xtrabackup-v2 SST)
• Revision #d4866c7d0d 2019-08-26 19:19:12 +0300
  • fix clang warnings
• Revision #f608713739 2019-08-27 08:30:26 +0300
  • Enable galera_sst_mysqldump_with_key test case.
• Revision #29bbf4749e 2019-08-27 09:13:20 +0400
  • MDEV-19699 Server crashes in Item_null_result::field_type upon SELECT with ROLLUP on constant table
• Revision #de0f93fb0d 2019-08-26 13:37:09 +0200
  • MDEV-20420: SST failed after MDEV-18863 in some test configurations
• Revision #4a9fb9055e 2019-08-26 14:03:51 +0530
  • MDEV-20188: binlog.binlog_stm_drop_tmp_tbl fails in buildbot with Unknown table on exec
• Revision #b01a95f6fc 2019-08-22 17:37:13 +0300
  • row_undo_mod_remove_clust_low(): Remove duplicated code
• Revision #5b29820d80 2019-08-22 11:11:22 +0300
  • Fix -Wstringop-truncation
• Revision #94e6a4fa6a 2019-08-21 11:12:39 +0200
  • Bash-specific operator replaced by a universal one
• Revision #91fdb931fa 2019-08-12 18:30:19 +0200
  • ensure that pam plugin is present in release packages
• Revision #62cc991bc8 2019-07-14 12:17:32 +0200
  • really make CPACK_RPM_DEBUGINFO_PACKAGE configurable
• Revision #9cd6e7ad73 2019-05-14 14:01:15 +0200
  • MDEV-16932: ASAN heap-use-after-free in my_charlen_utf8 / my_well_formed_char_length_utf8 on 2nd execution of SP with ALTER trying to add bad CHECK
• Revision #7aac83580a 2019-08-27 15:57:32 +0300
  • MDEV-13626: Add innodb.innodb-read-view
• Revision #25af2a183b 2019-08-27 15:48:46 +0300
  • MDEV-15326/MDEV-16136 dead code removal
• Revision #e7b71e0daa 2019-08-27 13:05:04 +0530
  • MDEV-19925: Column ... cannot be converted from type 'varchar(20)' to type 'varchar(20)'
• Revision #9bf424bc7b 2019-08-26 10:37:34 +0000
  • MDEV-20421 : Disable the test until fixed
• Revision #202243d59e 2019-08-26 10:58:27 +0000
  • MTR : improve detection of handles.exe on Windows.
• Revision #9de2e60d74 2019-08-21 11:38:17 +0300
  • MDEV-17187 table doesn't exist in engine after ALTER of FOREIGN KEY
• Revision #e279c0076d 2019-08-20 12:52:57 +0300
  • MDEV-17187: Code cleanup
• Revision #ddaebdd210 2019-08-20 14:55:49 +0300
  • dict_table_open_on_index_id(): Remove a redundant parameter
• Revision #1a3c77e524 2019-08-21 09:09:26 +0300
  • MDEV-19968: Galera test failure on galera_load_data
• Revision #6c06defb5f 2019-08-19 14:17:38 +0200
  • MDEV-15458 Segfault in heap_scan() upon UPDATE after ADD SYSTEM VERSIONING
• Revision #1ad70bf2fe 2019-08-20 13:06:53 +0200
  • Revert "Fixes a problem with heap when scanning and insert rows at the same time"
• Revision #4438ff07cd 2019-08-20 16:03:43 +0300
  • MDEV-20389: Refine the test case
• Revision #2850b8d844 2019-08-20 15:24:32 +0300
  • MDEV-20389 The test innodb.innodb_bug84958 fails intermittently
• Revision #6dd1d6cb90 2019-08-20 15:28:01 +0300
  • MDEV-20379 Mroonga has memory leak in ha_mroonga::is_foreign_key_field
• Revision #262927a9e5 2019-08-20 12:57:52 +0300
  • Fixes a problem with heap when scanning and insert rows at the same time
• Revision #64c6f2bffc 2019-08-20 09:50:35 +0300
  • After-merge fixes
• Merge Revision #48c67038b9 2019-08-20 09:15:28 +0300 - Merge 10.1 into 10.2
• Revision #bc89b1c558 2019-08-20 07:47:11 +0300
  • MDEV-18863: Fix -Wsign-compare
• Merge Revision #a02dd7e614 2019-08-20 07:31:44 +0300 - Merge 5.5 into 10.1
• Revision #e746f451d5 2019-08-15 17:27:49 -0700
  • MDEV-20265 Unknown column in field list
• Revision #a7e2cd55ab 2019-08-19 22:42:56 +0400
  • MDEV-19034 ASAN unknown-crash in get_date_time_separator with PAD_CHAR_TO_FULL_LENGTH
• Revision #457dc9d64d 2019-07-30 13:45:13 +0200
  • MDEV-18863: Galera SST scripts can't read [mysqldN] option groups
• Merge Revision #f987de7122 2019-08-16 20:58:14 +0400 - Merge remote-tracking branch 'origin/5.5' into 10.1
• Revision #ec1f195ecf 2019-08-16 14:32:44 +0400
  • MDEV-15955 Assertion `field_types == 0 || field_types[field_pos] == MYSQL_TYPE_LONGLONG' failed in Protocol_text::store_longlong
• Revision #ecdacf7264 2019-08-16 14:36:23 +0300
  • MDEV-19834 Selectivity of an equality condition discounted twice
• Revision #fa74088838 2019-08-15 07:46:41 +0300
  • MDEV-18778: mysql_tzinfo_to_sql does not work correctly in MariaDB Galera
• Revision #1c75ad6eed 2019-08-15 12:57:21 +0300
  • MDEV-19834 Selectivity of an equality condition discounted twice
• Revision #588e67956a 2019-08-13 19:29:59 +0300
  • Make sure histograms do not write uninitialized bytes to record
• Revision #12e3ac04fe 2019-07-30 17:16:25 +0200
  • MDEV-20185: Windows: Use of uninitialized value $bpath in string eq
• Revision #ff6d3075d5 2019-07-30 13:45:13 +0200
  • MDEV-18863: Galera SST scripts can't read [mysqldN] option groups
• Revision #68e6c2d768 2019-08-19 17:11:49 +0300
  • MDEV-20377: Introduce cmake -DWITH_MSAN:BOOL=ON
• Revision #e7fda5db07 2019-08-19 17:09:06 +0300
  • MDEV-20377: Fix uninitialized memory in mysqltest
• Revision #dc91372de3 2019-08-16 18:11:32 +0530
  • During ibd file creation, InnoDB flushes the page0 without crypt information. During recovery, InnoDB encounters encrypted page read before initialising the crypt data of the tablespace. So it leads t corruption of page and doesn't allow innodb to start.
• Revision #fe6eac0cf7 2019-08-16 09:50:54 +0300
  • MDEV-19200: shutdown timeout on innodb.undo_truncate_recover
• Revision #555af003e4 2019-08-16 09:54:33 +0300
  • MDEV-8588/MDEV-19740: Restore a condition
• Revision #112589cded 2019-08-15 15:29:32 +0300
  • MDEV-19740: Remove a bogus condition
• Revision #d07936aaba 2019-08-15 15:29:03 +0300
  • MDEV-19740: Silence a bogus "may be uninitialized" warning
• Revision #ec28f9532e 2019-08-15 15:06:27 +0300
  • MDEV-19740: Fix C++11 violations caught by GCC 9.2.1
• Revision #0b20b9e911 2019-08-15 12:53:08 +0300
  • Disable galera.query_cache as it still fails on bb and azure.
• Revision #29e560cdf3 2019-08-14 22:53:16 +0530
  • MDEV-20348: DROP TABLE IF EXISTS killed on master but was replicated
• Revision #2347ffd843 2019-08-09 00:31:35 +0300
  • MDEV-20301 InnoDB's MVCC has O(N^2) behaviors
• Revision #65296123d0 2019-08-13 16:37:21 +0300
  • MDEV-12439: MariaRocks produces numerous (spurious?) valgrind failures
• Revision #c5b4697b24 2019-08-13 16:27:51 +0300
  • MDEV-20315: Backport to 10.2: Myrocks: Get the upstream's valgrind suppressions to work
• Revision #a18d1cc777 2019-08-13 16:26:17 +0300
  • MDEV-20315: MyRocks tests produce valgrind failures (Backport to 10.2)
• Merge Revision #ed4ccf34a6 2019-08-13 13:33:23 +0300 - Merge 10.1 into 10.2
• Revision #c738aa240e 2019-08-13 12:39:08 +0300
  • MDEV-20138 innodb.trx_id_future fails on big-endian
• Revision #eff898f2a0 2019-08-13 12:30:36 +0300
  • MDEV-20335: Extra trans_commit_stmt after rollback caused by incorrect fix of MDEV-14401
• Revision #f13471c9fe 2019-08-13 13:14:23 +0300
  • MDEV-20060: Remove bogus unit from error message
• Revision #f25e9aa4ba 2019-08-13 11:37:01 +0300
  • MDEV-20310: Make InnoDB crash tests Valgrind-friendly
• Revision #5edc4ea4d9 2019-08-13 09:24:31 +0300
  • MDEV-20324: Galera threads are not registered to performance schema
• Revision #3cee665a04 2019-08-12 13:01:33 +0300
  • MDEV-17847 Galera test failure on MW-328[A|B|C]
• Revision #609ea2f37b 2019-08-12 18:50:54 +0300
  • MDEV-17614: After-merge fix
• Merge Revision #be33124c9d 2019-08-12 18:23:42 +0300 - Merge 10.1 into 10.2
• Merge Revision #15c1ab52a9 2019-08-12 14:46:28 +0300 - Merge 5.5 into 10.1
• Revision #1217e4a0c0 2019-08-12 14:12:32 +0300
  • Fix -Wimplicit-fallthrough
• Revision #b2a387a3f1 2019-08-12 14:05:26 +0300
  • Document TRASH_FILL, TRASH_ALLOC, TRASH_FREE
• Revision #cabf10b640 2019-07-31 09:53:58 -0400
  • bump the VERSION
• Revision #7a9e1fcd45 2019-08-12 14:45:28 +0300
  • MDEV-17614: Re-record a result
• Revision #284c72eacf 2019-07-17 15:56:29 +0530
  • MDEV-17614 INSERT on dup key update is replication unsafe
• Revision #47f8a18fec 2019-08-07 12:35:04 +0530
  • MDEV-20247 Replication hangs with "preparing" and never starts
• Revision #eef7540405 2019-08-05 14:34:13 +0530
  • MDEV-18930: Failed CREATE OR REPLACE TEMPORARY not written into binary log makes data on master and slave diverge
• Revision #319cec959c 2019-08-01 15:24:48 +0300
  • MDEV-17638 Improve error message about corruption of encrypted page
• Revision #f79212f96d 2019-07-31 02:49:15 -0700
  • Fix extra space in mysql-test README
• Revision #fe8181aca1 2019-08-12 15:40:57 +0300
  • Fixed issues found by valgrind
• Revision #3b234104ae 2019-08-10 01:46:50 +0300
  • MDEV-16955: rocksdb_sys_vars.rocksdb_update_cf_options_basic
• Revision #6765cc6077 2019-08-08 20:10:00 +0300
  • Fixed assertion Assertion `!table->pos_in_locked_tables' failed
• Revision #dbac2039e8 2019-08-08 20:05:40 +0300
  • Fixed some errors & warnings found by clang
• Revision #5fa2eb6f3d 2019-08-08 20:03:21 +0300
  • Fixed connect_debug.test to not depend on system error message
• Revision #6168f41401 2019-08-08 20:02:40 +0300
  • Updated BUILD/compile-pentium64-asan-max
• Revision #6dca5f6726 2019-08-08 22:55:35 +0300
  • revert accidental libmariadb change
• Revision #d39d5dd2bc 2019-07-29 14:12:19 +0300
  • MDEV-20060: Failing assertion: srv_log_file_size <= 512ULL << 30 while preparing backup
• Revision #88abca55f9 2019-08-06 12:56:16 +0300
  • fix build (-Werror + -Wignored-qualifiers)
• Revision #a5a7ab1957 2019-07-19 18:23:10 +0300
  • Cleanup: this is how to use span
• Revision #da7d82b8ea 2019-07-19 18:22:22 +0300
  • MDEV-20103 add a class similar to std::span
• Revision #988ff90256 2019-08-04 23:37:47 +0300
  • MDEV-20227: rocksdb.rocksdb_concurrent_delete fails on windows
• Revision #09a85692a6 2019-08-03 23:15:44 +0300
  • Post-merge fixes for rocksdb.group_min_max test
• Revision #05b35cf4c1 2019-07-31 09:57:31 -0400
  • bump the VERSION