Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.17.59.199
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
binlog /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
binlog_anonymous_ownership.tes...
11.78
KB
-rw-r--r--
binlog_bug23533.test
1.48
KB
-rw-r--r--
binlog_bug36391-master.opt
32
B
-rw-r--r--
binlog_bug36391.test
1.18
KB
-rw-r--r--
binlog_cache_write_failure-mas...
97
B
-rw-r--r--
binlog_cache_write_failure.tes...
5.4
KB
-rw-r--r--
binlog_check_flush_log_asserti...
1.68
KB
-rw-r--r--
binlog_checksum.test
1.08
KB
-rw-r--r--
binlog_crash_safe_master_check...
51
B
-rw-r--r--
binlog_crash_safe_master_check...
2.6
KB
-rw-r--r--
binlog_database.test
370
B
-rw-r--r--
binlog_delete_and_flush_index....
3.53
KB
-rw-r--r--
binlog_dmls_on_tmp_tables_read...
2.38
KB
-rw-r--r--
binlog_drop_if_exists.test
3.47
KB
-rw-r--r--
binlog_drop_temp_table_on_disc...
2
KB
-rw-r--r--
binlog_drop_temp_table_on_disc...
1.75
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
379
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
378
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
1.46
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
3.75
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
314
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
313
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
739
B
-rw-r--r--
binlog_enforce_gtid_consistenc...
409
B
-rw-r--r--
binlog_error_action-master.opt
88
B
-rw-r--r--
binlog_error_action.test
17.12
KB
-rw-r--r--
binlog_flush_logs_error.test
1.72
KB
-rw-r--r--
binlog_foreign_key_parent_tabl...
44
B
-rw-r--r--
binlog_foreign_key_parent_tabl...
1.08
KB
-rw-r--r--
binlog_format_switch_in_tmp_ta...
2.77
KB
-rw-r--r--
binlog_grant.test
1.83
KB
-rw-r--r--
binlog_grant_alter_user-master...
32
B
-rw-r--r--
binlog_grant_alter_user.test
39.59
KB
-rw-r--r--
binlog_group_commit_flush_cras...
51
B
-rw-r--r--
binlog_group_commit_flush_cras...
2.17
KB
-rw-r--r--
binlog_group_commit_gtid_order...
4.6
KB
-rw-r--r--
binlog_group_commit_indefinite...
1.51
KB
-rw-r--r--
binlog_group_commit_sync_delay...
1.84
KB
-rw-r--r--
binlog_group_commit_sync_delay...
1.23
KB
-rw-r--r--
binlog_group_commit_sync_no_de...
3.72
KB
-rw-r--r--
binlog_gtid_automatic_using_ro...
2.02
KB
-rw-r--r--
binlog_gtid_cache-master.opt
117
B
-rw-r--r--
binlog_gtid_cache.test
635
B
-rw-r--r--
binlog_gtid_errors-master.opt
149
B
-rw-r--r--
binlog_gtid_errors.test
9.1
KB
-rw-r--r--
binlog_gtid_exhausted-master.o...
77
B
-rw-r--r--
binlog_gtid_exhausted.test
3.3
KB
-rw-r--r--
binlog_gtid_implicit_commit.te...
121
B
-rw-r--r--
binlog_gtid_innodb.test
132
B
-rw-r--r--
binlog_gtid_mix_ok_packet_all_...
131
B
-rw-r--r--
binlog_gtid_mix_ok_packet_all_...
1.63
KB
-rw-r--r--
binlog_gtid_mix_response_packe...
99
B
-rw-r--r--
binlog_gtid_mix_response_packe...
1.82
KB
-rw-r--r--
binlog_gtid_mode_set_gtid_next...
4.66
KB
-rw-r--r--
binlog_gtid_mysqlbinlog_row.te...
197
B
-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...
707
B
-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...
661
B
-rw-r--r--
binlog_gtid_mysqlbinlog_start_...
444
B
-rw-r--r--
binlog_gtid_mysqldump.test
2.09
KB
-rw-r--r--
binlog_gtid_next_begin_caused_...
948
B
-rw-r--r--
binlog_gtid_next_partially_fai...
2.93
KB
-rw-r--r--
binlog_gtid_next_partially_fai...
9.45
KB
-rw-r--r--
binlog_gtid_next_single_stmt_t...
968
B
-rw-r--r--
binlog_gtid_next_temporary_tab...
2.73
KB
-rw-r--r--
binlog_gtid_next_xa.test
241
B
-rw-r--r--
binlog_gtid_ps_reprepare.test
6.56
KB
-rw-r--r--
binlog_gtid_purge_binlog_at_st...
3.72
KB
-rw-r--r--
binlog_gtid_rbr_only_flag.test
2.51
KB
-rw-r--r--
binlog_gtid_reset_consistency_...
2.61
KB
-rw-r--r--
binlog_gtid_row_ctype_ucs.test
265
B
-rw-r--r--
binlog_gtid_simple_recovery.te...
6
KB
-rw-r--r--
binlog_gtid_state_update_deadl...
2.62
KB
-rw-r--r--
binlog_gtid_stm_ctype_ucs.test
280
B
-rw-r--r--
binlog_gtid_unknown_xid.test
5.39
KB
-rw-r--r--
binlog_gtid_utils.test
3.56
KB
-rw-r--r--
binlog_gtids_table_gcov.test
2.86
KB
-rw-r--r--
binlog_implicit_commit.test
290
B
-rw-r--r--
binlog_incident.test
1.39
KB
-rw-r--r--
binlog_incident_ignore-master....
24
B
-rw-r--r--
binlog_incident_ignore.test
152
B
-rw-r--r--
binlog_index-master.opt
16
B
-rw-r--r--
binlog_index.test
16.86
KB
-rw-r--r--
binlog_innodb-master.opt
25
B
-rw-r--r--
binlog_innodb.test
139
B
-rw-r--r--
binlog_innodb_row.test
2.72
KB
-rw-r--r--
binlog_killed.test
9.71
KB
-rw-r--r--
binlog_killed_simulate-master....
39
B
-rw-r--r--
binlog_killed_simulate.test
2.7
KB
-rw-r--r--
binlog_max_extension.test
2.61
KB
-rw-r--r--
binlog_max_flush_queue_time_wa...
32
B
-rw-r--r--
binlog_max_flush_queue_time_wa...
850
B
-rw-r--r--
binlog_mixed_cache_stat.test
277
B
-rw-r--r--
binlog_mixed_load_data.test
535
B
-rw-r--r--
binlog_mts_logical_clock.test
2.35
KB
-rw-r--r--
binlog_mts_logical_clock_gtid....
318
B
-rw-r--r--
binlog_mysqlbinlog-cp932-maste...
23
B
-rw-r--r--
binlog_mysqlbinlog-cp932.test
1.11
KB
-rw-r--r--
binlog_mysqlbinlog_base64.test
2.64
KB
-rw-r--r--
binlog_mysqlbinlog_concat.test
4.28
KB
-rw-r--r--
binlog_mysqlbinlog_filter.test
2.07
KB
-rw-r--r--
binlog_mysqlbinlog_intvar.test
1.59
KB
-rw-r--r--
binlog_mysqlbinlog_raw.test
3.53
KB
-rw-r--r--
binlog_mysqlbinlog_rewrite_db....
6.58
KB
-rw-r--r--
binlog_mysqlbinlog_row.test
204
B
-rw-r--r--
binlog_mysqlbinlog_row_innodb....
714
B
-rw-r--r--
binlog_mysqlbinlog_row_myisam....
669
B
-rw-r--r--
binlog_mysqlbinlog_row_trans.t...
4.07
KB
-rw-r--r--
binlog_mysqlbinlog_start_stop....
452
B
-rw-r--r--
binlog_mysqlbinlog_start_stop_...
1.95
KB
-rw-r--r--
binlog_nogtid_mix_response_pac...
480
B
-rw-r--r--
binlog_noop_dml_with_readonly....
2.4
KB
-rw-r--r--
binlog_old_versions.test
5.22
KB
-rw-r--r--
binlog_purge_binary_logs_stall...
70
B
-rw-r--r--
binlog_purge_binary_logs_stall...
1.36
KB
-rw-r--r--
binlog_purge_binary_logs_to.te...
3.45
KB
-rw-r--r--
binlog_query_filter_rules-mast...
40
B
-rw-r--r--
binlog_query_filter_rules.test
855
B
-rw-r--r--
binlog_rbr_only_savepoint.test
2.83
KB
-rw-r--r--
binlog_reset_connection_not_re...
3.49
KB
-rw-r--r--
binlog_reset_master.test
996
B
-rw-r--r--
binlog_rewrite.test
2.99
KB
-rw-r--r--
binlog_rewrite_db_noleak.test
2.65
KB
-rw-r--r--
binlog_rewrite_order.test
1.07
KB
-rw-r--r--
binlog_rewrite_suppress_use.te...
2.25
KB
-rw-r--r--
binlog_rotate_bgc_sync.test
3.37
KB
-rw-r--r--
binlog_rotate_deadlock-master....
181
B
-rw-r--r--
binlog_rotate_deadlock.test
1.75
KB
-rw-r--r--
binlog_row_binlog-master.opt
55
B
-rw-r--r--
binlog_row_binlog.test
783
B
-rw-r--r--
binlog_row_cache_stat.test
274
B
-rw-r--r--
binlog_row_create_select_crash...
1.35
KB
-rw-r--r--
binlog_row_ctype_cp932.test
268
B
-rw-r--r--
binlog_row_ctype_ucs.test
272
B
-rw-r--r--
binlog_row_delete_all_rows.tes...
688
B
-rw-r--r--
binlog_row_drop_tbl.test
215
B
-rw-r--r--
binlog_row_drop_tmp_tbl.test
233
B
-rw-r--r--
binlog_row_innodb_stat-master....
26
B
-rw-r--r--
binlog_row_insert_select.test
708
B
-rw-r--r--
binlog_row_kill_create_select....
845
B
-rw-r--r--
binlog_row_mix_innodb_myisam-m...
97
B
-rw-r--r--
binlog_row_mix_innodb_myisam.t...
585
B
-rw-r--r--
binlog_row_mysqlbinlog_db_filt...
4.36
KB
-rw-r--r--
binlog_row_mysqlbinlog_verbose...
5.59
KB
-rw-r--r--
binlog_row_query_log_events.te...
942
B
-rw-r--r--
binlog_server_id.test
794
B
-rw-r--r--
binlog_server_start_options-ma...
54
B
-rw-r--r--
binlog_server_start_options.te...
1.14
KB
-rw-r--r--
binlog_set_gtid_mode_ongoing_t...
6.96
KB
-rw-r--r--
binlog_set_trans_dependency_de...
2.24
KB
-rw-r--r--
binlog_sf.test
2.67
KB
-rw-r--r--
binlog_shutdown_hang.test
1.14
KB
-rw-r--r--
binlog_simulate_crash_and_erro...
4.24
KB
-rw-r--r--
binlog_spurious_ddl_errors-mas...
20
B
-rw-r--r--
binlog_spurious_ddl_errors.tes...
4.16
KB
-rw-r--r--
binlog_sql_mode.test
4.75
KB
-rw-r--r--
binlog_start_comment.test
1.01
KB
-rw-r--r--
binlog_start_slave_heartbeat-s...
16
B
-rw-r--r--
binlog_start_slave_heartbeat.t...
1.33
KB
-rw-r--r--
binlog_stm_binlog-master.opt
55
B
-rw-r--r--
binlog_stm_binlog.test
741
B
-rw-r--r--
binlog_stm_blackhole.test
456
B
-rw-r--r--
binlog_stm_cache_stat.test
280
B
-rw-r--r--
binlog_stm_ctype_cp932.test
318
B
-rw-r--r--
binlog_stm_ctype_ucs.test
287
B
-rw-r--r--
binlog_stm_delete_all_rows.tes...
712
B
-rw-r--r--
binlog_stm_do_db-master.opt
38
B
-rw-r--r--
binlog_stm_do_db.test
2.8
KB
-rw-r--r--
binlog_stm_drop_tbl.test
230
B
-rw-r--r--
binlog_stm_drop_tmp_tbl.test
248
B
-rw-r--r--
binlog_stm_innodb_stat-master....
26
B
-rw-r--r--
binlog_stm_insert_select.test
489
B
-rw-r--r--
binlog_stm_mix_innodb_myisam-m...
145
B
-rw-r--r--
binlog_stm_mix_innodb_myisam.t...
552
B
-rw-r--r--
binlog_stm_ps.test
939
B
-rw-r--r--
binlog_stm_row.test
3.38
KB
-rw-r--r--
binlog_stm_unsafe_warning-mast...
51
B
-rw-r--r--
binlog_stm_unsafe_warning.test
5.65
KB
-rw-r--r--
binlog_stm_user_variables.test
3.4
KB
-rw-r--r--
binlog_switch_inside_trans.tes...
7.63
KB
-rw-r--r--
binlog_temporary_tables_user_v...
1.14
KB
-rw-r--r--
binlog_tmp_table.test
4.53
KB
-rw-r--r--
binlog_transaction_dependency_...
90
B
-rw-r--r--
binlog_transaction_dependency_...
8.21
KB
-rw-r--r--
binlog_transaction_dependency_...
2.2
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
1.98
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
1.33
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
1.21
KB
-rw-r--r--
binlog_transaction_write_set_s...
44
B
-rw-r--r--
binlog_transaction_write_set_s...
4.15
KB
-rw-r--r--
binlog_truncate_kill.test
1.96
KB
-rw-r--r--
binlog_truncate_myisam.test
348
B
-rw-r--r--
binlog_unsafe-master.opt
65
B
-rw-r--r--
binlog_unsafe.test
25.95
KB
-rw-r--r--
binlog_unsafe_stmt_capable_eng...
41
B
-rw-r--r--
binlog_unsafe_stmt_capable_eng...
12.55
KB
-rw-r--r--
binlog_use_gtid_skip.test
1.03
KB
-rw-r--r--
binlog_user_if_exists.test
9.22
KB
-rw-r--r--
binlog_variables_log_bin-maste...
16
B
-rw-r--r--
binlog_variables_log_bin.test
136
B
-rw-r--r--
binlog_variables_log_bin_index...
70
B
-rw-r--r--
binlog_variables_log_bin_index...
136
B
-rw-r--r--
binlog_variables_log_statement...
2.18
KB
-rw-r--r--
binlog_wait_for_executed_gtid_...
879
B
-rw-r--r--
binlog_wait_for_executed_gtid_...
2.45
KB
-rw-r--r--
binlog_wait_for_executed_gtid_...
633
B
-rw-r--r--
binlog_wait_for_executed_gtid_...
801
B
-rw-r--r--
binlog_write_error.test
2.7
KB
-rw-r--r--
binlog_writeset_history_protec...
3.06
KB
-rw-r--r--
binlog_wrong_last_committed.te...
3.07
KB
-rw-r--r--
binlog_xa_handling.test
3.69
KB
-rw-r--r--
binlog_xa_modify_gtid_executed...
2.93
KB
-rw-r--r--
binlog_xa_prepare_failure.test
2.05
KB
-rw-r--r--
binlog_xa_prepared_disconnect....
628
B
-rw-r--r--
binlog_xa_rollback_failure.tes...
1.4
KB
-rw-r--r--
binlog_xa_select_gtid_executed...
2.41
KB
-rw-r--r--
binlog_xa_trx_gtid_response_pa...
98
B
-rw-r--r--
binlog_xa_trx_gtid_response_pa...
1.1
KB
-rw-r--r--
binlog_xa_trx_split_across_bin...
2.51
KB
-rw-r--r--
disabled.def
404
B
-rw-r--r--
log_builtin_as_identified_by_p...
39
B
-rw-r--r--
log_builtin_as_identified_by_p...
128
B
-rw-r--r--
show_binlog_events_no_lock.tes...
2.27
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : binlog_gtid_next_partially_failed_stmts.test
# ==== Purpose ==== # # Verify that a partially failed statement saves its gtid into # @@GLOBAL.GTID_EXECUTED and is binlogged when binlog is enabled. # # ==== Implementation ==== # # 1) Execute a partially failed statement. # 2) When binlog is enabled, verify that the partially failed statement # saves its gtid into @@GLOBAL.GTID_EXECUTED if it is binlogged, or # does not save its gtid into @@GLOBAL.GTID_EXECUTED if it is not # binlogged. # 3) Execute above two steps for all different types of statements. # # ==== References ==== # # Bug#21686749 PARTIALLY FAILED DROP OR ACL STMT FAILS TO CONSUME GTID ON BINLOGLESS SLAVE # See mysql-test/t/no_binlog_gtid_next_partially_failed_stmts.test # See mysql-test/t/no_binlog_gtid_next_partially_failed_stmts_error.test # See mysql-test/suite/binlog/t/binlog_gtid_next_partially_failed_grant.test # See mysql-test/t/no_binlog_gtid_next_partially_failed_stmts_anonymous.test # # Test in this file is binlog format agnostic, thus no need # to rerun it for every format. --source include/have_binlog_format_row.inc --source include/have_gtid.inc # Make sure the test is repeatable RESET MASTER; --let $master_uuid= `SELECT @@GLOBAL.SERVER_UUID` CREATE TABLE t1(a INT, b INT); CREATE USER u1@h; --echo # --echo # Verify that u1 is added into mysql.user. --echo # SELECT user FROM mysql.user where user='u1'; # Check-1: GRANT --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --replace_result $master_uuid MASTER_UUID --error ER_BAD_FIELD_ERROR GRANT SELECT(a), SELECT(c) ON t1 TO u1@h; --echo # --echo # The SELECT privilege on column a is not granted to u1@h, --echo # which means that GRANT can not be failed partially when --echo # granting an available privilege and a non-available --echo # privilege to an existent user. --echo # SELECT user, column_name, column_priv FROM mysql.columns_priv; --echo # --echo # Verify that the failed GRANT statement does not generate --echo # a gtid and save the gtid into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:3 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-2" --source include/assert.inc --echo # --echo # Verify that the failed GRANT statement is not binlogged --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc GRANT SELECT(a) ON t1 TO u1@h; --echo # --echo # Verify that the grant info is added into mysql.columns_priv. --echo # SELECT user, column_name, column_priv FROM mysql.columns_priv; # Check-2: REVOKE --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --error ER_NONEXISTING_TABLE_GRANT REVOKE SELECT(a), SELECT(b) ON t1 FROM u1@h; --echo # --echo # The SELECT privilege is removed on column a from user u1, --echo # which means that REVOKE statement can be failed partially --echo # when revoking multiple privileges from a user. --echo # SELECT user, column_name, column_priv FROM mysql.columns_priv; --echo # --echo # Verify that the partially failed REVOKE statement does not generate --echo # a gtid master_uuid:5 and save the gtid into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:4 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-3" --source include/assert.inc --echo # --echo # Verify that the partially failed REVOKE statement is not binlogged --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Check-3: DROP USER --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --error ER_CANNOT_USER DROP USER u1@h, u2@h; --echo # --echo # The u1 is removed from mysql.user which means that DROP USER --echo # can be failed partially. --echo # SELECT user FROM mysql.user where user='u1'; --echo # --echo # Verify that the partially failed DROP USER statement generates --echo # a gtid and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:5 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-4" --source include/assert.inc --echo # --echo # Verify that the partially failed DROP USER statement is binlogged --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc CREATE VIEW v1 as SELECT 1; # Check-4: DROP VIEW --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --error ER_BAD_TABLE_ERROR DROP VIEW v1, v2; --echo # --echo # Verify that the partially failed DROP VIEW statement generates --echo # a gtid and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:7 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-6" --source include/assert.inc --echo # --echo # Verify that the partially failed DROP VIEW statement is binlogged --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Check-5: RENAME TABLE --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --error ER_FILE_NOT_FOUND RENAME TABLE t1 TO t2, t3 TO t4; --echo # --echo # The table t1 was not renamed, which means RENAME TABLE --echo # can not be failed partially. --echo # SHOW CREATE TABLE t1; --echo # --echo # Verify that the failed RENAME TABLE statement does not generate --echo # a new GTID MASTER_UUID:8 and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Does not generate MASTER_UUID:8 and commit it into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-6" --source include/assert.inc --echo # --echo # Verify that the failed RENAME TABLE statement is not binlogged --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Check-6: OPTIMIZE TABLE --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --echo # --echo # The OPTIMIZE TABLE statement can be failed partially when optimizing --echo # multiple tables, which contain a non-existent table. --echo # OPTIMIZE TABLE t1, t_non_existent; --echo # --echo # When optimizing a non-existent table, verify that the OPTIMIZE TABLE --echo # statement generates a gtid and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:8 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-7" --source include/assert.inc --echo # --echo # When optimizing a non-existent table, verify that the OPTIMIZE TABLE --echo # statement is binlogged. --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Check-7: ANALYZE TABLE --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --echo # --echo # The ANALYZE TABLE statement can be failed partially when analyzing --echo # multiple tables, which contain a non-existent table. --echo # ANALYZE TABLE t1, t_non_existent; --echo # --echo # When analyzing a non-existent table, verify that the ANALYZE TABLE --echo # statement generates a gtid and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:9 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-8" --source include/assert.inc --echo # --echo # When analyzing a non-existent table, verify that the ANALYZE TABLE --echo # statement is binlogged. --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Check-8: REPARE TABLE --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --echo # --echo # The REPAIR TABLE statement can be failed partially when repairing --echo # multiple tables, which contain a non-existent table. --echo # REPAIR TABLE t1, t_non_existent; --echo # --echo # When repairing a non-existent table, verify that the REPAIR TABLE --echo # statement generates a gtid and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Committed gtid MASTER_UUID:10 into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-9" --source include/assert.inc --echo # --echo # When repairing a non-existent table, verify that the REPAIR TABLE --echo # statement is binlogged. --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Check-8: CHECKSUM TABLE --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1) --echo # --echo # The CHECKSUM TABLE statement can be failed partially when checksuming --echo # multiple tables, which contain a non-existent table. --echo # CHECKSUM TABLE t1, t_non_existent; --echo # --echo # When checksuming a non-existent table, verify that the CHECKSUM TABLE --echo # statement generates a gtid and save it into @@GLOBAL.GTID_EXECUTED. --echo # --replace_result $master_uuid MASTER_UUID --let $assert_text= Does not generate MASTER_UUID:11 and commit it into @@GLOBAL.GTID_EXECUTED --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-9" --source include/assert.inc --echo # --echo # When checksuming a non-existent table, verify that the CHECKSUM TABLE --echo # statement is not binlogged. --echo # --let $binlog_start= $saved_master_pos --source include/show_binlog_events.inc # Clean up DROP TABLE t1;
Close
