Debian Codegraph @

mysql-test/suite/binlog/r/binlog_trigger.result

raw
1 #
2 # WL#3253: multiple triggers per table
3 #
4 # Testing that the FOLLOWS and PRECEDES clauses get logged
5 CREATE TABLE t1 (a INT, b INT);
6 CREATE TRIGGER tr1_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 100);
7 CREATE TRIGGER tr4_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 300);
8 CREATE TRIGGER tr2_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr1_bi INSERT INTO t2 (a) VALUES (NEW.a + 200);
9 CREATE TRIGGER tr3_bi BEFORE INSERT ON t1 FOR EACH ROW precedes tr4_bi INSERT INTO t2 (a) VALUES (NEW.a + 400);
10 DROP TABLE t1;
11 include/show_binlog_events.inc
12 Log_name Pos Event_type Server_id End_log_pos Info
13 master-bin.000001 # Gtid # # GTID #-#-#
14 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b INT)
15 master-bin.000001 # Gtid # # GTID #-#-#
16 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 100)
17 master-bin.000001 # Gtid # # GTID #-#-#
18 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr4_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 300)
19 master-bin.000001 # Gtid # # GTID #-#-#
20 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr2_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr1_bi INSERT INTO t2 (a) VALUES (NEW.a + 200)
21 master-bin.000001 # Gtid # # GTID #-#-#
22 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr3_bi BEFORE INSERT ON t1 FOR EACH ROW precedes tr4_bi INSERT INTO t2 (a) VALUES (NEW.a + 400)
23 master-bin.000001 # Gtid # # GTID #-#-#
24 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
25 #
26 # MDEV-25517 Atomic DDL: Assertion `query_arg' in THD::binlog_query
27 # upon DROP TRIGGER
28 #
29 CREATE TABLE t1 (a INT);
30 CREATE TRIGGER trg AFTER INSERT ON t1 FOR EACH ROW SET @x = 1;
31 connect con1,localhost,root,,test;
32 DROP TRIGGER trg;
33 connection default;
34 DROP TRIGGER trg;
35 connection con1;
36 disconnect con1;
37 connection default;
38 DROP TABLE t1;