Debian Codegraph @

mysql-test/suite/parts/inc/rpl-partition-dml-1-1.inc

raw
1 let $DATA_PATH=;
2 let $INDEX_PATH=;
3 --source include/master-slave.inc
4 set @old_global_binlog_format= @@global.binlog_format;
5 set @old_session_binlog_format= @@session.binlog_format;
6 SET GLOBAL binlog_format = 'ROW';
7 SET SESSION binlog_format = 'ROW';
8 select @@global.binlog_format, @@session.binlog_format;
9 --echo [on slave]
10 connection slave;
11 set @old_global_binlog_format= @@global.binlog_format;
12 set @old_session_binlog_format= @@session.binlog_format;
13 --source include/stop_slave.inc
14 SET GLOBAL binlog_format = 'ROW';
15 SET SESSION binlog_format = 'ROW';
16 select @@global.binlog_format, @@session.binlog_format;
17 # start slave so that slave sql thread's binlog format is re-read
18 # from @@global.binlog_format
19 --source include/start_slave.inc
20
21 connection master;
22
23 --echo # Additional tests for WL#5217 by QA, testplan 1.1
24
25 let $TABLENAME= t1;
26 --source suite/parts/inc/partition-dml_cr_tab.inc
27 --source suite/parts/inc/partition-dml_ins_tab.inc
28
29 --enable_connect_log
30
31 --sorted_result
32 SELECT * FROM t1 PARTITION (`p0-29`);
33 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
34 --sorted_result
35 SELECT * FROM t1 PARTITION (`p0-29`);
36
37 --sync_slave_with_master
38 --source include/check_slave_is_running.inc
39 --sorted_result
40 SELECT * FROM t1 PARTITION (`p0-29`);
41
42 connection master;
43 UPDATE t1 PARTITION (`p30-299`) SET b='p30-299-upd' WHERE a BETWEEN 30 AND 39;
44 --sorted_result
45 SELECT * FROM t1 PARTITION (`p30-299`);
46
47 --sync_slave_with_master
48 --source include/check_slave_is_running.inc
49 --sorted_result
50 SELECT * FROM t1 PARTITION (`p30-299`);
51
52 connection master;
53 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
54 --sorted_result
55 SELECT * FROM t1 PARTITION (`p300-2999`);
56
57 --sync_slave_with_master
58 --source include/check_slave_is_running.inc
59 --sorted_result
60 SELECT * FROM t1 PARTITION (`p300-2999`);
61
62 connection master;
63 UPDATE t1 PARTITION (subp3) SET b='subp3-upd';
64 UPDATE t1 PARTITION (subp4) SET b='subp4-upd';
65 UPDATE t1 PARTITION (subp5) SET b='subp5-upd';
66 --sorted_result
67 SELECT * FROM t1 PARTITION (subp4,subp5,subp3) order by b,a;
68
69 --sync_slave_with_master
70 --source include/check_slave_is_running.inc
71 --sorted_result
72 SELECT * FROM t1 PARTITION (subp4,subp5,subp3) order by b,a;
73 --source include/stop_slave_sql.inc
74 set @@global.binlog_format= @old_global_binlog_format;
75 --source include/start_slave_sql.inc
76 set @@session.binlog_format= @old_session_binlog_format;
77
78 connection master;
79 set @@global.binlog_format= @old_global_binlog_format;
80 set @@session.binlog_format= @old_session_binlog_format;
81 DROP TABLE t1;
82
83 --disable_connect_log