diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_truncate_2myisam.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_truncate_2myisam.result | 28 |
1 files changed, 20 insertions, 8 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_truncate_2myisam.result b/mysql-test/suite/rpl/r/rpl_truncate_2myisam.result index da8db64cef4..a8a08ef564d 100644 --- a/mysql-test/suite/rpl/r/rpl_truncate_2myisam.result +++ b/mysql-test/suite/rpl/r/rpl_truncate_2myisam.result @@ -1,35 +1,47 @@ include/master-slave.inc [connection master] include/rpl_reset.inc -**** On Master **** +connection master; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM; INSERT INTO t1 VALUES (1,1), (2,2); -**** On Master **** +connection slave; +connection master; TRUNCATE TABLE t1; +connection slave; include/diff_tables.inc [master:t1, slave:t1] ==== Test using a table with delete triggers ==== -**** On Master **** +connection master; SET @count := 1; CREATE TABLE t2 (a INT, b LONG) ENGINE=MyISAM; CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1; -**** On Master **** +connection slave; +connection master; TRUNCATE TABLE t1; +connection slave; include/diff_tables.inc [master:t2, slave:t2] +connection master; DROP TABLE t1,t2; +connection slave; include/rpl_reset.inc -**** On Master **** +connection master; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM; INSERT INTO t1 VALUES (1,1), (2,2); -**** On Master **** +connection slave; +connection master; DELETE FROM t1; +connection slave; include/diff_tables.inc [master:t1, slave:t1] ==== Test using a table with delete triggers ==== -**** On Master **** +connection master; SET @count := 1; CREATE TABLE t2 (a INT, b LONG) ENGINE=MyISAM; CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1; -**** On Master **** +connection slave; +connection master; DELETE FROM t1; +connection slave; include/diff_tables.inc [master:t2, slave:t2] +connection master; DROP TABLE t1,t2; +connection slave; include/rpl_end.inc |