Debian Codegraph @

mysql-test/suite/rpl/include/rpl_set_statement.inc

raw
1 #Check if the variable is replicated correctly with "SET STATEMENT"
2 # Usage:
3 # $rpl_ssvt_var_name - the name of tested variable;
4 # $rpl_ssvt_var_value - the value to set;
5 # $rpl_ssvt_table - the table name to insert values.
6
7 --connection master
8 eval SELECT @@$rpl_ssvt_var_name;
9
10 --connection slave
11 eval SELECT @@$rpl_ssvt_var_name;
12
13 --connection master
14 --disable_result_log
15 eval SET STATEMENT $rpl_ssvt_var_name=$rpl_ssvt_var_value FOR
16 INSERT INTO $rpl_ssvt_table VALUES(@@$rpl_ssvt_var_name);
17 --enable_result_log
18 eval SELECT @@$rpl_ssvt_var_name;
19
20 --sync_slave_with_master
21 eval SELECT * FROM $rpl_ssvt_table;
22 eval SELECT @@$rpl_ssvt_var_name;
23
24 --connection master
25 eval DELETE FROM $rpl_ssvt_table;
26