WL#9249: Move GTID enabled tests to separate rpl_gtid suite and GTID disabled tests to rpl_nogtid

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

Today, by default, rpl suite is run with different rpl configurations: 
for ex- gtid_mode = on, gtid_mode = off

Few rpl tests runs with GTIDs enabled and gets skipped when those tests are run 
with GTIDs disabled.

Few rpl tests runs with GTIDs disabled and gets skipped when those tests are run 
with GTIDs enabled.

To avoid unnecessary tests runs/skips, the purpose of this work-log is to minimize 
these skips by creating 2 new suites rpl_gtid, rpl_nogtid.

User Documentation
==================

This work is for the test suite. No user documentation needed.
FR1. All rpl tests that DO require GTID_MODE=ON SHALL be moved to a new suite 
rpl_gtid. 

FR2. All rpl tests that DO require GTID_MODE=OFF SHALL be moved to a new suite 
rpl_nogtid.

FR3. suite rpl_gtid WILL be added in the MTR default suite(s) list.

FR4: suite rpl_nogtid WILL be added in the MTR default suite(s) list.

FR5. rpl_gtid & rpl_nogtid WILL be run with 2 new configuration files (.cnf) with
     GTID enabled and GTID disabled respectively.

FR6. Additonal runs SHALL be made in the MTR collection files for rpl_gtid and 
     rpl_nogtid suite. 

rpl suite has tests which:

a) do not require GTIDs, but can run with or without GTIDs;
b) do not support GTIDs;
c) require GTIDs; 

This WL would do the following:

1.) move all (c) tests to the rpl_gtid suite,that runs only with GTIDs enabled. 
2.) move all (b) tests to the rpl_nogtid suite,that runs only with GTIDs disabled.
3.) Tests in rpl suite will continue to run with GTIDs because of (a) tests.

After this WL implementation, we will have 3 suites - rpl, rpl_gtid, rpl_nogtid.

Below 65 tests in the rpl suite runs only with GTIDs enabled. Following tests 
will be moved to a new suite rpl_gtid.

rpl_apply_binlog_with_anonymous_gtid_when_gtid_mode_on.test
rpl_check_gtid.test
rpl_current_user.test
rpl_drop_temp_gtid.test
rpl_empty_multi_update.test
rpl_explicit_modify_gtid_table.test
rpl_gtid_binary_log_as_relay_log.test
rpl_gtid_delete_memory_table_after_start_server.test
rpl_gtid_do_table_filter_insensitive.test
rpl_gtid_do_table_filter_sensitive.test
rpl_gtid_drop_table.test
rpl_gtid_dump_error.test
rpl_gtid_execution.test
rpl_gtid_heartbeat_2slave.test
rpl_gtid_ignore_table_filter_insensitive.test
rpl_gtid_ignore_table_filter_sensitive.test
rpl_gtid_loaddata_s.test
rpl_gtid_mts_replicate_same_server_id.test
rpl_gtid_mysqlbinlog_rotate.test
rpl_gtid_parallel.test
rpl_gtid_purged_fail_to_connect.test
rpl_gtid_purged_maintained.test
rpl_gtid_replay_relaylog.test
rpl_gtid_retrieve_last_trx.test
rpl_gtid_row_event_max_size.test
rpl_gtid_server_sighup.test
rpl_gtid_spanned_trx.test
rpl_gtid_split_statements.test
rpl_gtid_sql_until_before_after.test
rpl_gtids_table_disable_binlog_on_slave.test
rpl_gtids_table_disable_log_slave_updates.test
rpl_gtids_table.test
rpl_gtid_stress_failover.test
rpl_gtid_table_repository_split_trx.test
rpl_gtid_temp_table.test
rpl_gtid_transaction_split_across_relay_logs.test
rpl_gtid_validate_slave_gtids.test
rpl_low_slave_net_time_out.test
rpl_master_errors.test
rpl_master_pos_wait_after_startup.test
rpl_mts_execute_partial_trx_with_auto_pos_off.test
rpl_mts_execute_partial_trx_with_auto_pos_on_binlogless_slave.test
rpl_mts_execute_partial_trx_with_auto_pos_on.test
rpl_mts_logical_clock_wrong_start_pos.test
rpl_mts_until.test
rpl_mysqlbinlog_gtid_on.test
rpl_partial_gtid_trx_followed_by_anonymous_trx_by_receiver.test
rpl_partial_gtid_trx_followed_by_trx_at_startup.test
rpl_perfschema_applier_status_by_worker_last_seen_transaction.test
rpl_replication_observers_example_plugin_channels_receiver_thread.test
rpl_replication_observers_example_plugin_channels.test
rpl_replication_observers_example_plugin_server_requirements.test
rpl_reset_slave_all_thread_safe.test
rpl_rotate_gtid.test
rpl_sbm_previous_gtid_event.test
rpl_simulate_create_chunk_failure.test
rpl_stm_until_pos_middle_gtid.test
rpl_sync_relay_log_info.test
rpl_tablespace.test
rpl_transaction_before_commit_failure.test
rpl_transaction_ctx_service.test
rpl_trx_boundary_parser_row.test
rpl_trx_boundary_parser_stmt.test
rpl_wait_for_executed_gtid_set.test
rpl_wait_for_gtid_executed_unknown_uuid.test

Below 126 tests in the rpl suite runs only with GTIDs disabled. Following tests 
will be moved to a new suite rpl_nogtid.

default_row_format_02.test
rpl_000010.test
rpl_alter_repository.test
rpl_apply_binlog_with_gtid_when_gtid_mode_off.test
rpl_auto_increment_bug33029.test
rpl_begin_commit_rollback.test
rpl_binlog_corruption.test
rpl_binlog_gcommit_options.test
rpl_binlog_index.test
rpl_binlog_invalid_event.test
rpl_binlog_json.test
rpl_bug31076.test
rpl_change_master_crash_safe.test
rpl_change_master_relay_log_purge.test
rpl_change_master.test
rpl_checksum.test
rpl_circular_for_4_hosts.test
rpl_concurrency_error.test
rpl_create_if_not_exists.test
rpl_create_tmp_table_if_not_exists.test
rpl_cross_version.test
rpl_deadlock_innodb.test
rpl_do_db_filter.test
rpl_do_grant.test
rpl_do_table_filter_insensitive.test
rpl_do_table_filter_sensitive.test
rpl_drop_temp.test
rpl_extra_col_master_innodb.test
rpl_extra_col_master_myisam.test
rpl_extra_col_slave_innodb.test
rpl_extra_col_slave_myisam.test
rpl_failed_optimize.test
rpl_filter_dbs_dynamic.test
rpl_filter_tables_dynamic.test
rpl_filter_tables_not_exist.test
rpl_grant.test
rpl_gtid_create_select.test
rpl_gtid_mode.test
rpl_gtid_not_yet_determined.test
rpl_heartbeat_2slaves.test
rpl_heartbeat_ssl.test
rpl_ignore_db_filter.test
rpl_ignore_table_filter_insensitive.test
rpl_ignore_table_filter_sensitive.test
rpl_ignore_table.test
rpl_incident.test
rpl_invoked_features.test
rpl_loaddata_fatal.test
rpl_loaddatalocal.test
rpl_loaddata_s.test
rpl_loaddata.test
rpl_log_pos.test
rpl_manual_change_index_file.test
rpl_misc_functions.test
rpl_mixed_binlog_max_cache_size.test
rpl_mixed_ddl_dml.test
rpl_mixed_drop_create_temp_table.test
rpl_mixed_implicit_commit_binlog.test
rpl_mixed_mixing_engines.test
rpl_mts_debug.test
rpl_mts_submode_switch.test
rpl_multi_source_slave_skip_counter.test
rpl_multi_update2.test
rpl_multi_update4.test
rpl_mysqlbinlog_relay_start_position.test
rpl_no_gtid_delete_memory_table_after_start_server.test
rpl_no_gtid_split_statements.test
rpl_non_direct_mixed_mixing_engines.test
rpl_non_direct_row_mixing_engines.test
rpl_non_direct_stm_mixing_engines.test
rpl_parallel_change_master.test
rpl_parallel_load_data.test
rpl_parallel_start_stop.test
rpl_parallel_switch_sequential.test
rpl_perfschema_applier_status_by_worker.test
rpl_read_old_relay_log_info.test
rpl_read_only.test
rpl_relay_log_recovery_positions.test
rpl_replicate_do.test
rpl_replicate_ignore_db.test
rpl_rotate_logs.test
rpl_rotate_row_trans.test
rpl_row_binlog_max_cache_size.test
rpl_row_corruption.test
rpl_row_create_select.test
rpl_row_drop_create_temp_table.test
rpl_row_event_max_size.test
rpl_row_hash_scan.test
rpl_row_ignorable_event.test
rpl_row_img_eng_full.test
rpl_row_implicit_commit_binlog.test
rpl_row_lcase_tblnames.test
rpl_row_mixing_engines.test
rpl_row_mts_crash_safe.test
rpl_row_mysqlbinlog.test
rpl_row_tabledefs_2myisam.test
rpl_row_tabledefs_3innodb.test
rpl_row_until.test
rpl_semi_sync.test
rpl_server_uuid.test
rpl_set_gtid_mode_on_after_implicit_pre_commit.test
rpl_set_gtid_mode_ongoing_wait_function.test
rpl_slave_server_id_equal_to_zero.test
rpl_slave_skip.test
rpl_sp_effects.test
rpl_sporadic_master.test
rpl_sql_thread_killed_waiting_commit_lock.test
rpl_stm_000001.test
rpl_stm_binlog_max_cache_size.test
rpl_stm_drop_create_temp_table.test
rpl_stm_implicit_commit_binlog.test
rpl_stm_innodb.test
rpl_stm_lcase_tblnames.test
rpl_stm_loaddata_concurrent.test
rpl_stm_mixed_mts_crash_safe.test
rpl_stm_mixing_engines.test
rpl_stm_start_stop_slave.test
rpl_stm_stop_middle_group.test
rpl_stop_slave.test
rpl_switch_stm_row_mixed.test
rpl_temporary.test
rpl_temp_table_mix_row.test
rpl_trigger.test
rpl_typeconv.test
rpl_xa_survive_disconnect_mixed_engines.test
transactional_ddl_locking.test