2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
**** Resetting master and slave ****
11
include/start_slave.inc
13
CREATE TABLE t1 (a INT, b LONG) ENGINE=InnoDB;
14
INSERT INTO t1 VALUES (1,1), (2,2);
17
Comparing tables master:test.t1 and slave:test.t1
18
==== Test using a table with delete triggers ====
21
CREATE TABLE t2 (a INT, b LONG) ENGINE=InnoDB;
22
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
25
Comparing tables master:test.t2 and slave:test.t2
27
**** Resetting master and slave ****
28
include/stop_slave.inc
31
include/start_slave.inc
33
CREATE TABLE t1 (a INT, b LONG) ENGINE=InnoDB;
34
INSERT INTO t1 VALUES (1,1), (2,2);
37
Comparing tables master:test.t1 and slave:test.t1
38
==== Test using a table with delete triggers ====
41
CREATE TABLE t2 (a INT, b LONG) ENGINE=InnoDB;
42
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
45
Comparing tables master:test.t2 and slave:test.t2