Debian Codegraph @

mysql-test/suite/galera/t/rpl_row_annotate.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --echo # On node_2
5 --connection node_2
6 SET GLOBAL wsrep_on=OFF;
7 RESET MASTER;
8 SET GLOBAL wsrep_on=ON;
9
10 --echo # On node_1
11 --connection node_1
12 SET GLOBAL wsrep_on=OFF;
13 RESET MASTER;
14 SET GLOBAL wsrep_on=ON;
15 CREATE TABLE t1(i INT)ENGINE=INNODB;
16 INSERT INTO t1 VALUES(1);
17 DELETE FROM t1 WHERE i = 1;
18
19 --echo # On node_2
20 --connection node_2
21 INSERT INTO t1 VALUES(2);
22 DELETE FROM t1 WHERE i = 2;
23
24 --echo # On node_1
25 --connection node_1
26 --source include/binlog_start_pos.inc
27 let $start_pos= `select @binlog_start_pos`;
28 --replace_column 2 # 5 #
29 --replace_result $start_pos <start_pos>
30 --replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\//
31 --eval SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM $start_pos
32
33 --echo # On node_2
34 --connection node_2
35 --source include/binlog_start_pos.inc
36 let $start_pos= `select @binlog_start_pos`;
37 --replace_column 2 # 5 #
38 --replace_result $start_pos <start_pos>
39 --replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\//
40 --eval SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM $start_pos
41
42 # Cleanup
43 DROP TABLE t1;
44
45 --echo # End of test