summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/rpl/include/rpl_truncate_helper.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/include/rpl_truncate_helper.test')
-rw-r--r--mysql-test/suite/rpl/include/rpl_truncate_helper.test29
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;