MariaDB 10.2.9 Changelog

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.2

Release date: 27 Sep 2017

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.

• Revision #21614f4a85 2017-09-25 09:29:27 +0300

  • Corruption during online table-rebuilding ALTER of ROW_FORMAT=REDUNDANT tables

• 2017-09-22 21:47:38 +0300

  • Updated list of unstable tests for 10.2.9

• 2017-09-22 13:57:25 +0200

  • shut out Connect cmake-time warning about missing Findlibmondgodoc.cmake

• 2017-09-21 21:21:36 +0200

  • bugfix: copy timestamps correctly in INSERT...SELECT

• 2017-09-21 20:08:59 +0200

  • bugfix: ALTER TABLE and TIMESTAMPs around DST change time

• 2017-09-22 01:12:00 +0200

  • cannot insert 1288481126 in a timestamp column in Europe/Moscow

• Merge 2017-09-22 00:58:21 +0200 - Merge branch '10.1' into 10.2

• 2017-09-21 16:05:39 +0000

  • CMake : Do not use FindPkgConfig on Windows

• 2017-09-21 16:30:24 +0300

  • Fix that FLUSH TABLES FOR EXPORT also works for Aria tables.

• 2017-09-21 12:05:21 +0300

  • Correct debug assertions

• 2017-09-21 10:15:27 +0300

  • page_rec_is_leaf(): Fix sign mismatch warnings

• 2017-09-21 10:07:28 +0300

  • Fix bogus rec_get_offsets() debug assertion failures for ROW_FORMAT=REDUNDANT

• 2017-09-21 08:21:06 +0300

  • Avoid comparison of unsigned to signed

• 2017-09-20 12:53:57 +0200

  • libmariadbclient18 is broken when using mariadb repo instead of debian's

• 2017-09-20 22:46:25 +0300

  • Fix -Wimplicit-fallthrough warnings (no functional change)

• 2017-09-20 22:34:20 +0300

  • Fix ut_ad(!leaf) failure in rec_get_offsets_func() with spatial index

• 2017-09-20 18:09:45 +0300

  • Avoid comparison of unsigned to signed

• 2017-09-20 16:52:11 +0300

  • Allow ALTER TABLE…ADD SPATIAL INDEX…ALGORITHM=INPLACE

• 2017-09-20 14:55:14 +0300

  • Add a missing const qualifier

• 2017-09-19 19:20:11 +0300

  • Add the parameter bool leaf to rec_get_offsets()

• Merge 2017-09-20 10:46:09 +0300 - Merge branch '10.1' into 10.2

• Merge 2017-09-20 10:33:13 +0300 - Merge branch '10.2' of github.com:MariaDB/server into 10.2

• 2017-09-19 21:53:08 +0300

  • Remove DICT_UNIVERSAL

• 2017-09-20 08:17:06 +0300

  • Fix a typo

• 2017-09-19 12:40:29 +0300

  • Introduce page_rec_is_leaf() and clean up page0page.h

• 2017-09-19 19:24:00 +0300

  • Correct a test result

• 2017-09-20 00:45:09 +0300

  • Update libmariadb submodule

• 2017-09-20 00:37:51 +0300

  • Update testcase post merge

• 2017-09-19 17:23:55 +0300

  • Remove libmariadbclient18.links post merge

• 2017-09-18 18:57:17 +0300

  • : Server crashes in find_field_in_tables upon PS with window function and subquery

• 2017-09-11 22:46:11 +0300

  • : Server Crash on Execute of SQL Statement

• 2017-09-11 13:30:39 +0300

  • : Server crashes in set_field_to_null_with_conversions or in Field::set_notnull

• 2017-09-11 12:03:16 +0300

  • : FIRST_V throw SQL Fehler (1292): Incorrect datetime value

• Merge 2017-09-19 15:07:32 +0300 - Merge remote-tracking branch 'connect/10.2' into 10.2

• 2017-09-11 16:23:06 +0200

  • Enable MONGO for the C driver. Modified: modified: storage/connect/CMakeLists.txt

• 2017-09-04 22:32:02 +0200 *

  • Update version number modified: storage/connect/ha_connect.cc

• 2017-09-02 16:01:31 +0200 *

  • Add more trace to tbl_thread.test (to debug failure) modified: storage/connect/mysql-test/connect/r/tbl_thread.result modified: storage/connect/mysql-test/connect/t/tbl_thread.test

• 2017-09-02 14:57:49 +0200

  • Disable MONGO modified: storage/connect/CMakeLists.txt

• 2017-09-02 10:59:39 +0200 *

  • Fix MongoDB C Driver adding for CMAKE. Requires MongoDB C Driver version 1.7 now available modified: storage/connect/CMakeLists.txt

• 2017-08-31 01:22:50 +0200 *

  • Set MONGO_ENABLED modified: storage/connect/CMakeLists.txt

• 2017-08-29 17:35:27 +0200 *

  • New distribution enabling or disabling the MONGO table type modified: storage/connect/CMakeLists.txt modified: storage/connect/ha_connect.cc modified: storage/connect/mycat.cc

• 2017-08-26 16:18:43 +0200 *

  • Fix Replace sprintf by strcpy for opval modified: storage/connect/ha_connect.cc

• 2017-08-26 11:02:53 +0200 *

  • Fix JDBC UPDATE containing single or double quote chars produces wrong result in ha_connect::GetStringOption modified: storage/connect/ha_connect.cc

• 2017-08-17 16:13:01 +0200 *

  • Fix failing test tbl_thread on linux (and mask another fail until is fixed) modified: storage/connect/mysql-test/connect/r/tbl_thread.result modified: storage/connect/mysql-test/connect/t/tbl_thread.test

• Merge 2017-09-19 12:43:02 +0300 - Merge branch '10.1' into 10.2

• 2017-09-15 17:30:09 +0200

  • apparmor: allow to read /etc/mysql/mariadb.conf.d/*

• Merge 2017-09-18 19:32:03 +0300 - Merge pull request #446 from darkain/patch-1

• 2017-09-13 10:48:10 -0700

  • Fixes Galera on FreeBSD

• 2017-09-15 16:43:06 +0200

  • Interrupted SELECT fails with 1030: 'Got error 1 "Operation not permitted" from storage engine MyISAM'

• 2017-09-15 15:05:39 +0200

  • Spelling errors in the error message

• 2017-09-15 15:03:41 +0200

  • stack overflow (OpenSSL on Windows)

• 2017-09-15 15:02:24 +0200

  • Crash with indexed virtual columns and FK cascading deletes

• 2017-09-15 00:29:56 +0200

  • Bad result in view

• 2017-09-14 19:31:04 +0200

  • Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in virtual longlong Field_long::val_int

• 2017-09-14 15:10:23 +0200

  • CHECK constraints disallow NULL to pass through, violating SQL

• 2017-09-13 21:02:44 +0200

  • Server crash [mysqld got exception 0xc0000005]

• 2017-09-13 19:54:48 +0200

  • cleanup: remove dead code

• 2017-09-13 22:45:20 +0200

  • bugfix: mtr non-reliable failure detection

• 2017-09-13 12:42:45 +0200

  • bugfix: deadlock on shutdown

• 2017-08-26 00:32:43 +0200

  • cleanup

• 2017-09-08 20:12:57 +0200

  • compiler warning

• 2017-09-12 18:55:05 +0200

  • bugfix: TIME_FORMAT() should be ok in stored generated columns

• 2017-09-12 18:31:12 +0200

  • bugfix: TIME_FORMAT() allowed some non-time format specifiers

• 2017-09-11 14:29:15 +0200

  • client packages need my_global.h and/or my_config.h

• 2017-09-11 14:39:31 +0200

  • bugfix: don't overwrite tokudb.cnf during the build

• 2017-09-11 12:29:37 +0200

  • 10.2 uses deprecated openssl 1.0 apis even with 1.1

• 2017-09-14 00:32:37 +0200

  • bugfix: debian dependencies

• 2017-09-12 15:07:00 +0200

  • bugfix: debian, fix *.so symlinks in libmariadb-dev

• 2017-09-10 13:50:05 +0200

  • libmariadbclient18 is broken when using mariadb repo instead of debian's

• 2017-08-24 14:05:32 +0200

  • bugfix: allow dropping a constraint and a column together

• Merge 2017-09-18 11:10:21 +0300 - Merge 10.1 into 10.2

• 2017-09-18 11:10:06 +0300

  • Fix the WSREP build

• 2017-09-13 19:51:30 +0300

  • : DELETE with CASCADE takes a long time when Galera is enabled

• 2017-08-25 11:33:13 +0300

  • MW-402 cascading FK issue (5.7 version)

• 2017-09-13 19:51:30 +0300

  • : DELETE with CASCADE takes a long time when Galera is enabled

• 2017-08-25 11:33:13 +0300

  • MW-402 cascading FK issue (5.7 version)

• 2017-08-24 10:34:21 +0300

  • MW-402 cascading FK issues

• Merge 2017-09-17 13:54:43 +0300 - Null-merge 10.1 into 10.2

• 2017-09-17 13:46:51 +0300

  • after-merge test fix: Exercise row_merge_write(), row_merge_read()

• Merge 2017-09-16 22:31:53 +0300 - Merge 10.1 into 10.2

• 2017-09-15 20:44:03 +0000

  • add updated result file for test.

• 2017-09-15 20:09:41 +0300

  • Field_varstring: Declare get_data() and get_length() as public

• 2017-09-15 17:25:38 +0300

  • Remove the redundant function row_table_got_default_clust_index()

• 2017-09-14 16:42:09 +0000

  • mariadb-backup --lock-ddl-per-table fails when table names contain backticks

• 2017-09-13 12:10:48 +0000

  • mariadb-backup : Fix enumerate_ibd_files() to include .isl

• 2017-07-27 11:43:33 +0300

  • MW-394

• 2017-07-27 11:39:31 +0300

  • MW-394

• 2017-07-25 10:56:44 +0300

  • MW-394

• 2017-09-14 16:07:10 +0300

  • Merge InnoDB test cases from MySQL 5.7 (part 2)

• 2017-09-14 14:30:24 +0400

  • Make compiler happy with the 'fall through' comments.

• 2017-09-14 11:16:40 +0400

  • Compiler warning avoided.

• 2017-09-14 08:58:31 +0300

  • Follow-up to mariadb-backup --lock-ddl-per-table

• 2017-09-14 08:06:40 +0300

  • Fix one more warning for page_header_get_field()

• 2017-09-14 08:00:28 +0300

  • Fix warnings for page_header_get_field() comparisons

• 2017-09-14 07:52:32 +0300

  • Fix a warning for a debug assertion

• 2017-09-13 15:41:04 +0300

  • Clean up the logging of virtual column values in table-rebuilding online ALTER

• 2017-09-13 11:04:49 +0300

  • Remove the debug variables innodb_purge_stop_now, innodb_purge_run_now

• 2017-09-13 09:31:13 +0300

  • Do not require a debug non-embedded server in the test

• 2017-09-13 09:27:15 +0300

  • Return uint16_t instead of ulint

• 2017-09-13 16:45:42 +0400

  • Server in ORACLE mode crashes on ALTER with wrong DEFAULT clause

• 2017-09-13 15:17:28 +0400

  • JSON_ARRAY() - bad output with some UTF8 characters.

• 2017-09-13 00:36:09 +0400

  • Wrong result from JSON native function.

• 2017-09-12 19:15:31 +0400

  • Wrong result from JSON native function.

• 2017-09-12 17:30:46 +0400

  • JSON_EXTRACT fails with some escaped unicode as key.

• 2017-09-12 15:33:30 +0400

  • compiler complains about uninitialized variable.

• 2017-09-12 15:21:53 +0400

  • Json functions.

• 2017-09-12 14:40:18 +0400

  • JSON_SET returns NULL instead of object.

• 2017-09-12 13:32:09 +0300

  • : rocksdb.index_merge_rocksdb2 failed in buildbot

• 2017-09-12 13:26:03 +0400

  • JSON_OBJECT returns null with strings containing backticks.

• 2017-09-11 16:47:23 +0300

  • Crash recovery failure after the server is killed during innodb_encrypt_log startup

• 2017-09-12 09:22:11 +0300

  • Relax a too strict debug assertion for mariadb-backup --prepare

• 2017-09-12 11:58:49 +0400

  • point_big test fails in 10.2.

• 2017-09-12 11:20:30 +0400

  • JSON_EXTRACT returns data for invalid JSON.

• 2017-09-11 16:45:36 +0000

  • lock DDL for mariadb-backup in 10.2

• 2017-09-07 11:13:08 +0200

  • PREPARE doesn't work as expected & throws errors but MySQL is working fine

• Merge 2017-09-08 15:38:02 +0300 - Merge InnoDB test cases from MySQL 5.7 (part 1)

• 2017-09-08 15:28:50 +0300

  • Adjust the imported innodb.alter_crash test for MariaDB

• 2017-09-08 15:33:03 +0300

  • Merge InnoDB test cases from MySQL 5.7 (part 1)

• 2017-09-08 09:38:42 +0300

  • Make a test more robust

• 2017-09-08 08:33:41 +0200

  • Windows : Fix MTR's misuse of servers --console parameter

• 2017-09-07 22:53:21 +0000

  • Implement --export option for MariaDB Backup

• Merge 2017-09-07 12:12:31 +0300 - Merge 10.1 into 10.2

• 2017-09-06 19:32:56 +0300

  • Fix a typo to silence -Wimplicit-fallthrough

• Merge 2017-09-06 19:28:51 +0300 - Merge 10.1 into 10.2

• 2017-09-06 19:08:55 +0300

  • Fix nondeterministic failure of innodb.table_flags

• 2017-09-06 16:29:58 +0300

  • mariadb-backup: Detach the threads at exit

• 2017-09-06 17:20:31 +0200

  • : Group By in a View, called within a Stored Routine causes Error Code 1356 when a non-root user runs the routine for a second time

• 2017-09-05 23:00:59 +0530

  • : RocksDB plugin fails to build on macOS because of unknown type timer_t etc.

• 2017-09-05 18:28:05 +0300

  • Update test results for rocksdb.bulk_load_rev_cf_and_data

• 2017-07-06 14:03:23 +0300

• 2017-09-03 09:33:27 +0200

  • Fix bash expansion issue in wsrep_sst_rsync (#443)

• 2017-09-01 22:07:43 +0300

  • Follow-up to Assertion failure !srv_read_only_mode in --innodb-read-only shutdown when buf_resize_thread is active

• 2017-09-01 11:23:45 +0300

  • After-merge fix for a Galera test result

• 2017-09-01 08:38:19 +0300

  • Fix test for : Deprecate innodb_use_mtflush and innodb_mtflush_threads

• Merge 2017-08-31 18:06:11 +0300 - Merge 10.1 into 10.2

• 2017-08-31 14:35:35 +0300

  • Disable a badly written, randomly failing Galera test

• 2017-08-31 13:36:36 +0300

  • : Deprecate innodb_use_mtflush and innodb_mtflush_threads

• 2017-05-11 11:15:37 +0300

  • : innodb.ibuf_not_empty failed in buildbot with "InnoDB: Trying to do I/O to a tablespace which does not exist"

• 2017-08-31 11:42:41 +0300

  • : Some MyRocks test take a long time

• Merge 2017-08-31 11:14:28 +0300 - Merge 10.1 into 10.2

• Merge 2017-08-31 09:35:39 +0300 - Merge 10.1 into 10.2

• 2017-08-31 08:20:29 +0300

  • Add ATTRIBUTE_NORETURN and ATTRIBUTE_COLD

• 2017-08-31 08:20:43 +0300

  • Fix some badly written Galera tests

• Merge 2017-08-31 09:28:59 +0300 - Merge 10.1 into 10.2

• 2017-08-29 14:23:34 +0300

  • : Startup failure, unable to decrypt ibdata1

• 2017-08-28 16:10:25 +0000

  • One more attempt to fix dependencies with mysqld import/export libraries with Visual Studio

• 2017-08-29 14:54:04 +0000

  • small refactoring o innobase/CMakeLists.txt

• 2017-08-30 14:37:16 +0000

  • Fix threadpool to report connections aborted due to wait timeout.

• 2017-08-30 11:45:24 +0300

  • : Some MyRocks test take a long time

• 2017-08-22 15:56:53 +1000

  • submodules.cmake: git returns 128 if not in a repository

• Merge 2017-08-29 10:07:33 +0300 - Merge 10.1 into 10.2

• 2017-08-28 19:41:13 +0300

  • Fix results for parts/repair_table test after enabling it for MyISAM

• 2017-08-28 13:46:31 +0300

  • Correct a mtr.add_suppression() expression

• 2017-08-28 08:57:51 +0300

  • InnoDB change buffer housekeeping can cause redo log overrun and possibly deadlocks

• 2017-08-24 12:51:05 +0530

  • Update README.md

• 2017-08-24 10:13:07 +0300

  • InnoDB STATS_PERSISTENT fails to ignore garbage delete-mark flag on node pointer pages

• 2017-08-23 18:40:47 +0300

  • : rocksdb.index_merge_rocksdb2 failed in buildbot

• 2017-08-23 14:40:23 +0300

  • The test failed once on Buildbot with the result difference:

• 2017-08-23 11:35:34 +0300

  • Adjust InnoDB debug assertions for Oracle Bug#25551311 aka Bug#23517560

• 2017-08-23 10:01:48 +0300

  • InnoDB key rotation is not skipping unused pages

• 2017-08-23 09:47:50 +0300

  • Code clean-up related to

• 2017-08-21 18:56:46 +0300

  • MTR tests fail massively with --innodb-sync-debug

• 2017-08-22 14:56:17 +0300

  • Remove the unused redo log record type MLOG_INIT_FILE_PAGE

• 2017-08-23 08:05:50 +0300

  • Assertion `!recv_no_log_write' failed at startup

• 2017-08-21 16:12:09 +0300

  • Fix rocksdb.bulk_load test

• 2017-08-21 15:26:21 +0300

  • : Update test results for rocksdb.bulk_load_rev_cf

• 2017-08-18 15:01:32 +0300

  • encryption.innodb-redo-badkey failed in buildbot

• 2017-08-18 14:42:53 +0300

  • Assertion failure !srv_read_only_mode in --innodb-read-only shutdown when buf_resize_thread is active

• 2017-08-18 14:42:18 +0300

  • On failure, mariadb-backup --backup --safe-slave-backup may forget to START SLAVE SQL_THREAD

• 2017-08-18 12:51:28 -0400

  • bump the VERSION

• 2017-08-18 10:07:11 +0300

  • Memory leak in mariadb-backup.incremental_backup

• 2017-08-18 10:00:56 +0300

  • related mariadb-backup code cleanup (non-functional change)

• 2017-08-18 08:52:41 +0300

  • Follow-up fix to backup fails if innodb_undo_tablespaces>0

• 2017-08-18 02:51:30 +0300

  • Updated list of unstable tests for 10.2.8

• 2017-08-18 02:48:43 +0300

  • gcol.gcol_rollback could fail with errors in server log

• 2017-08-17 15:07:44 +0000

  • : do not spam error log, if DeviceIoControl(IOCTL_STORAGE_QUERY_PROPERTY) fails with ERROR_INVALID_FUNCTION

• 2017-08-17 15:38:41 +0300

  • backup fails if innodb_undo_tablespaces>0