Debian Codegraph @

mysql-test/suite/rpl/t/rpl_set_statement.test

raw
1 --source include/master-slave.inc
2 --source include/have_binlog_format_statement.inc
3 set sql_mode="";
4 connection slave;
5 set sql_mode="";
6 connection master;
7
8 --disable_warnings
9 DROP TABLE IF EXISTS t1;
10 DROP TABLE IF EXISTS t2;
11 --enable_warnings
12
13 call mtr.add_suppression("Unsafe statement written to the binary log*");
14 CREATE TABLE t1 (a bigint unsigned not null);
15 CREATE TABLE t2 (a char(255) not null);
16
17 --echo
18 --echo There are the following types of variables:
19 --echo 1) variables that are NOT replicated correctly when using STATEMENT mode;
20 --echo
21
22 --let $rpl_ssvt_var_name=max_join_size
23 --let $rpl_ssvt_var_value=2
24 --let $rpl_ssvt_table=t1
25 --source suite/rpl/include/rpl_set_statement.inc
26
27 --echo
28 --echo 2) variables thar ARE replicated correctly
29 --echo They must be replicated correctly with "SET STATEMENT" too.
30 --echo
31 --let $rpl_ssvt_var_name=auto_increment_increment
32 --let $rpl_ssvt_var_value=10
33 --let $rpl_ssvt_table=t1
34 --source suite/rpl/include/rpl_set_statement.inc
35
36 --echo
37 --echo 3) sql_mode which is replicated correctly exept NO_DIR_IN_CREATE value;
38 --echo
39 --let $rpl_ssvt_var_name=sql_mode
40 --let $rpl_ssvt_var_value='ERROR_FOR_DIVISION_BY_ZERO'
41 --let $rpl_ssvt_table=t2
42 --source suite/rpl/include/rpl_set_statement.inc
43 --let $rpl_ssvt_var_name=sql_mode
44 --let $rpl_ssvt_var_value='NO_DIR_IN_CREATE'
45 --let $rpl_ssvt_table=t2
46 --source suite/rpl/include/rpl_set_statement.inc
47
48 --echo
49 --echo 4) variables that are not replicated at all:
50 --echo default_storage_engine, storage_engine, max_heap_table_size
51 --echo
52 --let $rpl_ssvt_var_name=max_heap_table_size
53 --let $rpl_ssvt_var_value=16384
54 --let $rpl_ssvt_table=t1
55 --source suite/rpl/include/rpl_set_statement.inc
56
57 connection master;
58 DROP TABLE t1;
59 DROP TABLE t2;
60 sync_slave_with_master;
61 source include/stop_slave.inc;