3
source include/wait_for_slave_to_stop.inc;
6
DROP TABLE IF EXISTS t1;
10
DROP TABLE IF EXISTS t1;
1
source include/reset_master_and_slave.inc;
15
3
--echo **** On Master ****
17
eval SET SESSION BINLOG_FORMAT=$format;
18
eval SET GLOBAL BINLOG_FORMAT=$format;
20
5
eval CREATE TABLE t1 (a INT, b LONG) ENGINE=$engine;
21
6
INSERT INTO t1 VALUES (1,1), (2,2);
23
--echo **** On Slave ****
24
sync_slave_with_master;
25
INSERT INTO t1 VALUE (3,3);
27
--echo **** On Master ****
31
--echo **** On Slave ****
32
sync_slave_with_master;
35
--echo **** On Master ****
38
let $SERVER_VERSION=`select version()`;
39
source include/show_binlog_events.inc;
7
sync_slave_with_master;
8
--echo **** On Master ****
11
sync_slave_with_master;
13
let $diff_table_1=master:test.t1;
14
let $diff_table_2=slave:test.t1;
15
source include/diff_tables.inc;
17
--echo ==== Test using a table with delete triggers ====
18
--echo **** On Master ****
21
eval CREATE TABLE t2 (a INT, b LONG) ENGINE=$engine;
22
CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1;
23
sync_slave_with_master;
24
--echo **** On Master ****
27
sync_slave_with_master;
29
let $diff_table_1=master:test.t2;
30
let $diff_table_2=slave:test.t2;
31
source include/diff_tables.inc;
35
sync_slave_with_master;