Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 create database mysqltest;
5 connection master;
6 drop database if exists mysqltest;
7 Warnings:
8 Note 1008 Can't drop database 'mysqltest'; database doesn't exist
9 connection slave;
10 show tables from mysqltest;
11 ERROR 42000: Unknown database 'mysqltest'
12 connection slave;
13 create table t1 (a int);
14 connection master;
15 drop table if exists t1;
16 Warnings:
17 Note 1051 Unknown table 'test.t1'
18 connection slave;
19 select * from t1;
20 ERROR 42S02: Table 'test.t1' doesn't exist
21 connection master;
22 create table t1 (a int, b int);
23 connection slave;
24 insert into t1 values(1,1);
25 connection master;
26 delete from t1;
27 connection slave;
28 select * from t1;
29 a b
30 insert into t1 values(1,1);
31 connection master;
32 insert into t1 values(2,1);
33 update t1 set a=2;
34 connection slave;
35 select * from t1;
36 a b
37 2 1
38 2 1
39 connection master;
40 create table t2 (a int, b int);
41 delete from t1;
42 insert into t1 values(1,1);
43 insert into t2 values(1,1);
44 connection slave;
45 update t1 set a=2;
46 connection master;
47 UPDATE t1, t2 SET t1.a = t2.a;
48 connection slave;
49 select * from t1;
50 a b
51 1 1
52 select * from t2;
53 a b
54 1 1
55 connection master;
56 delete from t1;
57 delete from t2;
58 connection slave;
59 insert into t1 values(1,1);
60 insert into t2 values(1,1);
61 connection master;
62 DELETE t1.*, t2.* from t1, t2;
63 connection slave;
64 select * from t1;
65 a b
66 select * from t2;
67 a b
68 connection master;
69 drop table t1, t2;
70 connection slave;
71 include/rpl_end.inc