Debian Codegraph @

mysql-test/suite/rpl/r/rpl_truncate_2myisam.result

raw
1 include/master-slave.inc
2 [connection master]
3 include/rpl_reset.inc
4 connection master;
5 CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
6 INSERT INTO t1 VALUES (1,1), (2,2);
7 connection slave;
8 connection master;
9 TRUNCATE TABLE t1;
10 connection slave;
11 include/diff_tables.inc [master:t1, slave:t1]
12 ==== Test using a table with delete triggers ====
13 connection master;
14 SET @count := 1;
15 CREATE TABLE t2 (a INT, b LONG) ENGINE=MyISAM;
16 CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
17 connection slave;
18 connection master;
19 TRUNCATE TABLE t1;
20 connection slave;
21 include/diff_tables.inc [master:t2, slave:t2]
22 connection master;
23 DROP TABLE t1,t2;
24 connection slave;
25 include/rpl_reset.inc
26 connection master;
27 CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM;
28 INSERT INTO t1 VALUES (1,1), (2,2);
29 connection slave;
30 connection master;
31 DELETE FROM t1;
32 connection slave;
33 include/diff_tables.inc [master:t1, slave:t1]
34 ==== Test using a table with delete triggers ====
35 connection master;
36 SET @count := 1;
37 CREATE TABLE t2 (a INT, b LONG) ENGINE=MyISAM;
38 CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
39 connection slave;
40 connection master;
41 DELETE FROM t1;
42 connection slave;
43 include/diff_tables.inc [master:t2, slave:t2]
44 connection master;
45 DROP TABLE t1,t2;
46 connection slave;
47 include/rpl_end.inc