Debian Codegraph @

mysql-test/suite/binlog/t/binlog_trigger.test

raw
1 --source include/not_embedded.inc
2 --source include/have_binlog_format_statement.inc
3
4 --disable_query_log
5 reset 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
14 CREATE TABLE t1 (a INT, b INT);
15 CREATE TRIGGER tr1_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 100);
16 CREATE TRIGGER tr4_bi BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 (a) VALUES (NEW.a + 300);
17 CREATE TRIGGER tr2_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr1_bi INSERT INTO t2 (a) VALUES (NEW.a + 200);
18 CREATE TRIGGER tr3_bi BEFORE INSERT ON t1 FOR EACH ROW precedes tr4_bi INSERT INTO t2 (a) VALUES (NEW.a + 400);
19 DROP TABLE t1;
20
21
22 --let $binlog_file = LAST
23 source include/show_binlog_events.inc;
24
25 --echo #
26 --echo # MDEV-25517 Atomic DDL: Assertion `query_arg' in THD::binlog_query
27 --echo # upon DROP TRIGGER
28 --echo #
29
30 # This test case is 'random' by design. For most cases the second DROP TRIGGER
31 # will generate a warning "Dropped orphan trigger...", but if there is a timing
32 # issue, we may get another error or warning later. This is ok as it enables
33 # us to have more code paths tested over time.
34
35 CREATE TABLE t1 (a INT);
36 CREATE TRIGGER trg AFTER INSERT ON t1 FOR EACH ROW SET @x = 1;
37 --disable_warnings
38 --connect (con1,localhost,root,,test)
39 --send
40 DROP TRIGGER trg;
41 --connection default
42 --error 0,ER_TRG_DOES_NOT_EXIST
43 DROP TRIGGER trg;
44 # Cleanup
45 --connection con1
46 --error 0,ER_TRG_DOES_NOT_EXIST
47 --reap
48 --disconnect con1
49 --connection default
50 --enable_warnings
51 DROP TABLE t1;