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
1
include/master-slave.inc
5
CREATE TABLE t1 (a INT, b LONG) ENGINE=InnoDB;
6
INSERT INTO t1 VALUES (1,1), (2,2);
9
include/diff_tables.inc [master:t1, slave:t1]
10
==== Test using a table with delete triggers ====
13
CREATE TABLE t2 (a INT, b LONG) ENGINE=InnoDB;
14
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
17
include/diff_tables.inc [master:t2, slave:t2]
21
CREATE TABLE t1 (a INT, b LONG) ENGINE=InnoDB;
22
INSERT INTO t1 VALUES (1,1), (2,2);
25
include/diff_tables.inc [master:t1, slave:t1]
26
==== Test using a table with delete triggers ====
29
CREATE TABLE t2 (a INT, b LONG) ENGINE=InnoDB;
30
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
33
include/diff_tables.inc [master:t2, slave:t2]