EVOLUTION-MANAGER

Edit File: rpl_truncate_2myisam.result

include/master-slave.inc [connection master] include/rpl_reset.inc connection master; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM; INSERT INTO t1 VALUES (1,1), (2,2); connection slave; connection master; TRUNCATE TABLE t1; connection slave; include/diff_tables.inc [master:t1, slave:t1] ==== Test using a table with delete triggers ==== 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; 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 connection master; CREATE TABLE t1 (a INT, b LONG) ENGINE=MyISAM; INSERT INTO t1 VALUES (1,1), (2,2); connection slave; connection master; DELETE FROM t1; connection slave; include/diff_tables.inc [master:t1, slave:t1] ==== Test using a table with delete triggers ==== 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; 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