MDEV-11130 Update the list of unstable tests for 10.1

1 files changed, 79 insertions, 75 deletions

diff --git a/mysql-test/unstable-tests b/mysql-test/unstable-tests
index 82713424daa..528c36a4a13 100644
--- a/mysql-test/unstable-tests
+++ b/mysql-test/unstable-tests
@@ -23,65 +23,56 @@
 #
 ##############################################################################
 
+main.alter_table                   : Modified in 10.1.19
 main.analyze_stmt_slow_query_log   : MDEV-7558 - wrong result
-main.bootstrap                     : Modified on 2016-06-18 (MDEV-9969)
 main.create_delayed                : MDEV-10605 - failed with timeout
-main.create_or_replace             : Modified on 2016-06-23 (MDEV-9728)
-main.ctype_recoding                : Modified on 2016-06-10 (MDEV-10181)
-main.ctype_utf8                    : Modified on 2016-06-21 (merge)
-main.ctype_utf8mb4                 : Modified on 2016-06-21 (merge)
+main.create_or_replace             : Modified in 10.1.19
 main.ctype_utf16le                 : MDEV-10675: timeout or extra warnings
-main.events_1                      : Modified on 2016-06-21 (MDEV-9524)
+main.drop                          : Modified in 10.1.19
+main.events_restart                : MDEV-11221: assertion failure
 main.func_group                    : Modified on 2016-08-08 (MDEV-10468)
-main.func_in                       : Modified on 2016-06-20 (MDEV-10020)
 main.func_math                     : Modified on 2016-08-10 (merge)
 main.func_misc                     : Modified on 2016-08-10 (merge)
 main.grant2                        : Modified on 2016-07-18 (MDEV-8569)
-main.help                          : Modified on 2016-06-21 (MDEV-9524)
 main.host_cache_size_functionality : MDEV-10606 - sporadic failure on shutdown
 main.index_intersect_innodb        : MDEV-10643 - failed with timeout
-main.index_merge_innodb            : MDEV-7142 - sporadic wrong execution plan
+main.information_schema            : Modified in 10.1.19
 main.information_schema_stats      : Modified on 2016-07-25 (MDEV-10428)
 main.innodb_mysql_lock             : MDEV-7861 - sporadic lock detection failure
-main.insert_innodb                 : Modified on 2016-06-14 (merge from upstream)
 main.kill_processlist-6619         : MDEV-10793 - wrong result in processlist
 main.loaddata                      : Modified on 2016-08-10 (merge)
-main.locale                        : Modified on 2016-06-21 (merge)
 main.mdev-504                      : MDEV-10607 - sporadic "can't connect"
 main.mdev375                       : MDEV-10607 - sporadic "can't connect"
 main.merge                         : MDEV-10607 - sporadic "can't connect"
-main.multi_update                  : Modified on 2016-06-20 (MDEV-5973)
 main.myisam_enable_keys-10506      : New test, added on 2016-08-10 (MDEV-10506)
+main.mysql                         : Modified in 10.1.19
+main.mysql_not_windows             : Modified in 10.1.19
 main.mysqlcheck                    : Modified on 2016-08-10 (merge)
-main.mysqldump                     : MDEV-10512 - sporadic assertion failure
-main.mysqltest                     : MDEV-9269 - fails on Alpha
+main.mysqldump-nl                  : Added in 10.1.19
+main.mysqltest                     : MDEV-9269 - fails on Alpha; also modified in 10.1.19
 main.named_pipe                    : Modified on 2016-08-02 (MDEV-10383)
+main.null                          : Modified in 10.1.19
 main.openssl_1                     : Modified on 2016-07-11 (MDEV-10211)
 main.order_by_optimizer_innodb     : MDEV-10683 - wrong execution plan
-main.parser                        : Modified on 2016-06-21 (merge)
 main.pool_of_threads               : MDEV-10100 - sporadic error on detecting max connections
 main.ps                            : MDEV-11017 - sporadic wrong Prepared_stmt_count
 main.ps_1general                   : Modified on 2016-07-12 (merge)
 main.range                         : Modified on 2016-08-10 (merge)
 main.range_mrr_icp                 : Modified on 2016-08-10 (merge)
-main.query_cache                   : MDEV-10611 - sporadic mutex problem
+main.selectivity                   : Modified in 10.1.19
+main.selectivity_innodb            : Modified in 10.1.19
 main.show_explain                  : MDEV-10674 - sporadic failure
-main.shutdown                      : MDEV-10612 - sporadic crashes
+main.shutdown                      : MDEV-10563 - sporadic crashes
 main.sp-prelocking                 : Modified on 2016-08-10 (merge)
 main.sp-security                   : MDEV-10607 - sporadic "can't connect"
-main.ssl                           : MDEV-10211 - different ciphers on some platforms
 main.ssl_ca                        : Modified on 2016-07-11 (MDEV-10211)
 main.ssl_compress                  : Modified on 2016-07-11 (MDEV-10211)
 main.ssl_timeout                   : Modified on 2016-07-11 (MDEV-10211)
 main.stat_tables_par_innodb        : MDEV-10515 - sporadic wrong results
 main.status                        : MDEV-8510 - sporadic wrong result
-main.status_user                   : Modified on 2016-06-20 (MDEV-8633)
-main.subselect                     : Modified in 10.1.17
 main.subselect_innodb              : MDEV-10614 - sporadic wrong results
-main.subselect_sj_mat              : Modified in 10.1.17
-main.temp_table                    : Modified on 2016-06-18 (MDEV-8569)
+main.subselect_sj_mat              : Modified on 2016-07-27 (MDEV-10389)
 main.type_date                     : Modified on 2016-08-10 (merge)
-main.type_datetime                 : Modified on 2016-06-16 (MDEV-9374)
 main.type_datetime_hires           : MDEV-10687 - timeout
 main.view                          : Modified on 2016-08-10 (merge)
 main.xtradb_mrr                    : Modified on 2016-08-04 (MDEV-9946)
@@ -94,7 +85,6 @@ archive.discover    : MDEV-10510 - table is marked as crashed
 #----------------------------------------------------------------
 
 binlog.binlog_commit_wait                 : MDEV-10150 - Error: too much time elapsed
-binlog.binlog_dmls_on_tmp_tables_readonly : New test, added on 2016-05-04 (upstream)
 binlog.binlog_xa_recover                  : MDEV-8517 - Extra checkpoint
 
 #----------------------------------------------------------------
@@ -107,6 +97,44 @@ connect.jdbc-postgresql : New test, added on 2016-07-13
 
 #----------------------------------------------------------------
 
+encryption.create_or_replace                : MDEV-9359 - Assertion failure
+encryption.encrypt_and_grep                 : MDEV-11222 - InnoDB error
+encryption.innodb-bad-key-change            : uses keys2.txt modified in 10.1.19
+encryption.innodb-bad-key-change2           : uses keys2.txt modified in 10.1.19
+encryption.innodb-bad-key-change3           : uses keys2.txt modified in 10.1.19
+encryption.innodb-bad-key-change4           : uses keys2.txt modified in 10.1.19
+encryption.innodb-bad-key-change5           : uses keys2.txt modified in 10.1.19
+encryption.innodb-bad-key-shutdown          : MDEV-9105 - valgrind warnings, assertion failures, and uses keys2.txt modified in 10.1.19
+encryption.innodb_encryption_discard_import : MDEV-11218 - wrong result, also modified in 10.1.19
+encryption.innodb_encryption_filekeys       : MDEV-9962 - timeouts
+encryption.innodb_encryption_tables         : MDEV-10970 - Crash/assertion failure
+encryption.innodb_first_page                : MDEV-10689 - crashes
+encryption.innodb-missing-key               : Added in 10.1.19
+encryption.innodb_onlinealter_encryption    : MDEV-10099 - wrong results
+encryption.innodb-page_encryption           : MDEV-10641 - mutex problem
+encryption.innodb-page_encryption_compression : MDEV-10739 - timeouts
+encryption.innodb_page_encryption_key_change  : uses keys2.txt modified in 10.1.19
+
+#----------------------------------------------------------------
+
+extra/binlog_tests.database      : Modified in 10.1.19 (merge)
+
+#----------------------------------------------------------------
+
+federated.federatedx             : MDEV-10617 - Wrong checksum, timeouts
+federated.federated_innodb       : MDEV-10617, MDEV-10417 - Wrong checksum, timeouts, fails on Mips
+federated.federated_partition    : MDEV-10417 - Fails on Mips
+federated.federated_transactions : MDEV-10617, MDEV-10417 - Wrong checksum, timeouts, fails on Mips
+
+#----------------------------------------------------------------
+
+funcs_1.processlist_priv_no_prot : Include file modified on 2016-07-12 (merge)
+funcs_1.processlist_priv_ps      : Include file modified on 2016-07-12 (merge)
+funcs_1.processlist_val_no_prot  : MDEV-11223 - Wrong result
+funcs_2.memory_charset           : MDEV-10290 - timeout
+
+#----------------------------------------------------------------
+
 galera.GAL-382 : New test, added in 10.1.17
 galera.MW-252  : New test, added in 10.1.17
 galera.MW-258  : New test, added in 10.1.17
@@ -144,28 +172,8 @@ galera_3nodes.galera_ist_gcache_rollover : Modified in 10.1.17
 galera_3nodes.galera_pc_bootstrap : Modified in 10.1.17
 galera_3nodes.galera_pc_weight : Modified in 10.1.17
 
-#----------------------------------------------------------------
-
-encryption.create_or_replace                : MDEV-9359 - Assertion failure
-encryption.innodb-bad-key-shutdown          : MDEV-9105 - valgrind warnings, assertion failures
-encryption.innodb_encryption_discard_import : MDEV-9099 - warnings, errors, crash
-encryption.innodb_encryption_filekeys       : MDEV-9962 - timeouts
-encryption.innodb_first_page                : MDEV-10689 - crashes
-encryption.innodb_onlinealter_encryption    : MDEV-10099 - wrong results
-encryption.innodb-page_encryption           : MDEV-10641 - mutex problem
-
-#----------------------------------------------------------------
-
-federated.federatedx             : MDEV-10617 - Wrong checksum, timeouts
-federated.federated_innodb       : MDEV-10617, MDEV-10417 - Wrong checksum, timeouts, fails on Mips
-federated.federated_partition    : MDEV-10417 - Fails on Mips
-federated.federated_transactions : MDEV-10617, MDEV-10417 - Wrong checksum, timeouts, fails on Mips
-
-#----------------------------------------------------------------
-
-funcs_1.processlist_priv_no_prot : Include file modified on 2016-07-12 (merge)
-funcs_1.processlist_priv_ps      : Include file modified on 2016-07-12 (merge)
-funcs_2.memory_charset           : MDEV-10290 - timeout
+galera.*        : Added to default suites in 10.1.19
+galera_3nodes.* : Added to default suites in 10.1.19
 
 #----------------------------------------------------------------
 
@@ -173,20 +181,19 @@ innodb.binlog_consistent              : MDEV-10618 - Server fails to start
 innodb.innodb-alter-table             : MDEV-10619 - Testcase timeout
 innodb.innodb-alter-tempfile          : Modified on 2016-08-09 (MDEV-10469)
 innodb.innodb_blob_truncate           : MDEV-10377 - Assertion failure
-innodb.innodb-bug-14068765            : MDEV-9105 - valgrind warnings, assertion failures
-innodb.innodb_corrupt_bit             : Modified on 2016-06-21 (merge)
-innodb.innodb-bug-14084530            : MDEV-9105 - valgrind warnings, assertion failures
+innodb.innodb-bug-14068765            : MDEV-9105 - valgrind warnings, assertion failures, also uses innodb-util.pl added in 10.1.19
+innodb.innodb-bug-14084530            : MDEV-9105 - valgrind warnings, assertion failures, also uses innodb-util.pl added in 10.1.19
 innodb.innodb_bug30423                : MDEV-7311 - Wrong number of rows in the plan
 innodb.innodb-fk-warnings             : Modified on 2016-07-18 (MDEV-8569)
-innodb.innodb-fkcheck                 : Modified on 2016-06-13 (MDEV-10083)
 innodb.innodb-page_compression_zip    : MDEV-10641 - mutex problem
 innodb.innodb_stats                   : MDEV-10682 - wrong result
 innodb.innodb_sys_semaphore_waits     : MDEV-10331 - wrong result
-innodb.innodb-wl5522                  : MDEV-9105 - valgrind warnings, assertion failures
-innodb.innodb-wl5522-1                : MDEV-9105 - valgrind warnings, assertion failures
-innodb.innodb-wl5522-debug-zip        : MDEV-10427 - Warning: database page corruption
-innodb.innodb-wl5522-zip              : MDEV-9105 - valgrind warnings, assertion failures
-innodb.xa_recovery                    : MDEV-10685 - warnings
+innodb.innodb-wl5522                  : MDEV-9105 - valgrind warnings, assertion failures, also uses innodb-util.pl added in 10.1.19
+innodb.innodb-wl5522-1                : MDEV-9105 - valgrind warnings, assertion failures, also uses innodb-util.pl added in 10.1.19
+innodb.innodb-wl5522-debug            : modified in 10.1.19
+innodb.innodb-wl5522-debug-zip        : MDEV-10427 - Warning: database page corruption, also modified in 10.1.19
+innodb.innodb-wl5522-zip              : MDEV-9105 - valgrind warnings, assertion failures, also uses innodb-util.pl added in 10.1.19
+innodb.xa_recovery                    : Modified in 10.1.19
 
 #----------------------------------------------------------------
 
@@ -194,6 +201,10 @@ innodb_zip.innodb_prefix_index_liftedlimit : MDEV-10686 - timeout
 
 #----------------------------------------------------------------
 
+maria.encrypt-wrong-key : uses keys2.txt modified in 10.1.19
+
+#----------------------------------------------------------------
+
 mroonga/storage.column_datetime_32bit_2038                         : Wrong result on Alpha
 mroonga/storage.column_datetime_32bit_before_unix_epoch            : Wrong result on Alpha
 mroonga/storage.column_datetime_32bit_max                          : Wrong result on Alpha
@@ -219,18 +230,10 @@ parts.partition_int_myisam   : MDEV-10621 - Testcase timeout
 
 #----------------------------------------------------------------
 
-perfschema.digest_table_full                 : Modified on 2016-06-21 (merge)
 perfschema.func_file_io                      : MDEV-5708 - fails for s390x
 perfschema.func_mutex                        : MDEV-5708 - fails for s390x
-perfschema.rpl_gtid_func                     : Modified on 2016-06-21 (merge)
 perfschema.setup_actors                      : MDEV-10679 - rare crash
-perfschema.sizing_low                        : Modified on 2016-04-26 (5.6.30 merge)
 perfschema.socket_summary_by_event_name_func : MDEV-10622 - Socket summary tables do not match
-perfschema.start_server_low_digest           : Modified on 2016-06-21 (merge)
-perfschema.statement_digest                  : Modified on 2016-06-21 (merge)
-perfschema.statement_digest_consumers        : Modified on 2016-06-21 (merge)
-perfschema.statement_digest_long_query       : Modified on 2016-06-21 (merge)
-perfschema.table_name                        : New test, added on 2016-04-26 (5.6.30 merge)
 perfschema.threads_mysql                     : MDEV-10677 - sporadic wrong result
 
 #----------------------------------------------------------------
@@ -243,11 +246,6 @@ plugins.thread_pool_server_audit : MDEV-9562 - crashes on sol10-sparc
 
 #----------------------------------------------------------------
 
-roles.rpl_grant_revoke_current_role-8638 : New test, added on 2016-06-20 (MDEV-8638)
-roles.set_role-9614                      : New test, added on 2016-05-30 (MDEV-9614)
-
-#----------------------------------------------------------------
-
 rpl.last_insert_id                    : MDEV-10625 - warnings in error log
 rpl.rpl_auto_increment                : MDEV-10417 - Fails on Mips
 rpl.rpl_auto_increment_bug45679       : MDEV-10417 - Fails on Mips
@@ -257,13 +255,13 @@ rpl.rpl_checksum_cache                : MDEV-10626 - Testcase timeout
 rpl.rpl_circular_for_4_hosts          : MDEV-10627 - Testcase timeout
 rpl.rpl_ddl                           : MDEV-10417 - Fails on Mips
 rpl.rpl_domain_id_filter_restart      : MDEV-10684 - Wrong result
+rpl.rpl_drop_db                       : Modified in 10.1.19
 rpl.rpl_gtid_basic                    : MDEV-10681 - server startup problem
 rpl.rpl_gtid_crash                    : MDEV-9501 - Warning: failed registering on master
 rpl.rpl_gtid_master_promote           : MDEV-10628 - Timeout in sync_with_master
 rpl.rpl_gtid_mdev9033                 : MDEV-10680 - warnings
 rpl.rpl_gtid_stop_start               : MDEV-10629 - Crash on shutdown
 rpl.rpl_gtid_until                    : MDEV-10625 - warnings in error log
-rpl.rpl_ignore_table                  : Modified on 2016-06-22
 rpl.rpl_innodb_bug30888               : MDEV-10417 - Fails on Mips
 rpl.rpl_insert                        : MDEV-9329 - Fails on Ubuntu/s390x
 rpl.rpl_insert_delayed                : MDEV-9329 - Fails on Ubuntu/s390x
@@ -273,15 +271,17 @@ rpl.rpl_mdev6020                      : MDEV-10630, MDEV-10417 - Timeouts, fails
 rpl.rpl_mdev6386                      : MDEV-10631 - Wrong result on slave
 rpl.rpl_parallel                      : MDEV-10632, MDEV-10653 - Failures to sync, timeouts
 rpl.rpl_parallel_optimistic           : MDEV-10511 - timeout
+rpl.rpl_parallel_retry                : MDEV-11119 - Server crash
 rpl.rpl_parallel_temptable            : MDEV-10356 - Crash in close_thread_tables
 rpl.rpl_partition_innodb              : MDEV-10417 - Fails on Mips
 rpl.rpl_row_drop_create_temp_table    : MDEV-10626 - Testcase timeout
 rpl.rpl_row_log_innodb                : MDEV-10688 - Wrong result
 rpl.rpl_row_sp001                     : MDEV-9329 - Fails on Ubuntu/s390x
 rpl.rpl_show_slave_hosts              : MDEV-10681 - server startup problem
+rpl.rpl_semi_sync                     : MDEV-11220 - Wrong result
 rpl.rpl_semi_sync_uninstall_plugin    : MDEV-7140 - Wrong plugin status
 rpl.rpl_slave_grp_exec                : MDEV-10514 - Unexpected deadlock
-rpl.rpl_switch_stm_row_mixed          : MDEV-10611 - Wrong usage of mutex
+rpl.rpl_stop_slave_error              : Modified in 10.1.19
 rpl.rpl_sync                          : MDEV-10633 - Database page corruption
 rpl.rpl_temporary_error2              : MDEV-10634 - Wrong number of retries
 rpl.sec_behind_master-5114            : MDEV-8518 - Wrong value of Seconds_Behind_Master
@@ -300,6 +300,10 @@ spider/bg.vp_fixes              : MDEV-9329 - Fails on Ubuntu/s390x
 
 #----------------------------------------------------------------
 
+storage_engine* : Tests are not always timely maintained
+
+#----------------------------------------------------------------
+
 stress.ddl_innodb : MDEV-10635 - Testcase timeout
 
 #----------------------------------------------------------------
@@ -317,7 +321,6 @@ sys_vars.wsrep_max_ws_size_basic               : Modified in 10.1.17
 
 #----------------------------------------------------------------
 
-tokudb.background_job_manager        : MDEV-10327 - Assertion failure on server shutdown
 tokudb.cluster_filter                : MDEV-10678 - Wrong execution plan
 tokudb.cluster_filter_hidden         : MDEV-10678 - Wrong execution plan
 tokudb.cluster_filter_unpack_varchar : MDEV-10636 - Wrong execution plan
@@ -333,13 +336,13 @@ tokudb_bugs.*                        : MDEV-9891 - massive crashes on shutdown
 
 tokudb_parts.*                       : MDEV-9891 - massive crashes on shutdown
 
-rpl-tokudb.*                         : MDEV-9891 - massive crashes on shutdown, also modified on 2016-06-10 (Merge)
+rpl-tokudb.*                         : MDEV-9891 - massive crashes on shutdown
 
 tokudb_add_index.*                   : MDEV-9891 - massive crashes on shutdown
 tokudb_backup.*                      : MDEV-9891 - massive crashes on shutdown
 tokudb_mariadb.*                     : MDEV-9891 - massive crashes on shutdown
-tokudb_sys_vars.*                    : MDEV-9891 - massive crashes on shutdown
 tokudb_rpl.*                         : MDEV-9891 - massive crashes on shutdown
+tokudb_sys_vars.*                    : MDEV-9891 - massive crashes on shutdown
 
 #----------------------------------------------------------------
 
@@ -347,12 +350,13 @@ unit.ma_test_loghandler : MDEV-10638 - record read not ok
 
 #----------------------------------------------------------------
 
-vcol.charsets         : Added on 2016-06-23
 vcol.not_supported    : MDEV-10639 - Testcase timeout
 vcol.vcol_keys_innodb : MDEV-10639 - Testcase timeout
 
 #----------------------------------------------------------------
 
-wsrep.* : MDEV-10041 - server crashes sporadically during bootstrap
+wsrep.mdev_10186 : Modified in 10.1.19
 
+#----------------------------------------------------------------
 
+wsrep_info.* : suite.pm modified in 10.1.19