From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/rpl/include/rpl_truncate_helper.test | 29 ++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 mysql-test/suite/rpl/include/rpl_truncate_helper.test (limited to 'mysql-test/suite/rpl/include/rpl_truncate_helper.test') 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; -- cgit v1.2.3