1--source include/not_embedded.inc 2--source include/have_binlog_format_statement.inc 3 4--disable_query_log 5reset master; # get rid of previous tests binlog 6--enable_query_log 7 8--echo # 9--echo # WL#3253: multiple triggers per table 10--echo # 11 12--echo # Testing that the FOLLOWS and PRECEDES clauses get logged 13 14CREATE TABLE t1 (a INT, b INT); 15CREATE TRIGGER tr1_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 100); 16CREATE TRIGGER tr4_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 300); 17CREATE TRIGGER tr2_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr1_bi INSERT INTO t2 (a) VALUES (NEW.a + 200); 18CREATE TRIGGER tr3_bi BEFORE INSERT ON t1 FOR EACH ROW precedes tr4_bi INSERT INTO t2 (a) VALUES (NEW.a + 400); 19DROP TABLE t1; 20 21 22--let $binlog_file = LAST 23source include/show_binlog_events.inc; 24