diff options
Diffstat (limited to 'mysql-test/suite/rpl/include/rpl_truncate_helper.test')
-rw-r--r-- | mysql-test/suite/rpl/include/rpl_truncate_helper.test | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/include/rpl_truncate_helper.test b/mysql-test/suite/rpl/include/rpl_truncate_helper.test new file mode 100644 index 00000000..ddfba6c5 --- /dev/null +++ b/mysql-test/suite/rpl/include/rpl_truncate_helper.test @@ -0,0 +1,29 @@ +--source include/rpl_reset.inc + +connection master; +eval CREATE TABLE t1 (a INT, b LONG) ENGINE=$engine; +INSERT INTO t1 VALUES (1,1), (2,2); +sync_slave_with_master; +connection master; +eval $trunc_stmt t1; +sync_slave_with_master; + +let $diff_tables= master:t1, slave:t1; +source include/diff_tables.inc; + +--echo ==== Test using a table with delete triggers ==== +connection master; +SET @count := 1; +eval CREATE TABLE t2 (a INT, b LONG) ENGINE=$engine; +CREATE TRIGGER trg1 BEFORE DELETE ON t1 FOR EACH ROW SET @count := @count + 1; +sync_slave_with_master; +connection master; +eval $trunc_stmt t1; +sync_slave_with_master; + +let $diff_tables= master:t2, slave:t2; +source include/diff_tables.inc; + +connection master; +DROP TABLE t1,t2; +sync_slave_with_master; |