Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_stm_mystery22.result

raw
1 include/master-slave.inc
2 [connection master]
3 create table t1(n int auto_increment primary key, s char(10));
4 connection slave;
5 insert into t1 values (2,'old');
6 connection master;
7 insert into t1 values(NULL,'new');
8 insert into t1 values(NULL,'new');
9 connection slave;
10 select * from t1 order by n;
11 n s
12 1 new
13 2 old
14 delete from t1 where n = 2;
15 include/start_slave.inc
16 include/stop_slave.inc
17 connection master;
18 create table t2(n int);
19 drop table t2;
20 insert into t1 values(NULL,'new');
21 set sql_log_bin=0;
22 insert into t1 values(NULL,'new');
23 set sql_log_bin=1;
24 delete from t1 where n=4;
25 connection slave;
26 include/start_slave.inc
27 select * from t1 order by n;
28 n s
29 1 new
30 2 new
31 3 new
32 connection master;
33 drop table t1;
34 connection slave;
35 include/rpl_end.inc