Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_trigger_multi_db.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 set global slave_run_triggers_for_rbr=1;
5 connection master;
6 CREATE TABLE t1 (a int);
7 connection slave;
8 connection slave;
9 CREATE DATABASE db2;
10 CREATE FUNCTION db2.get_value(a INT) RETURNS int(2) RETURN 0;
11 #
12 # Test Insert_rows_log_event
13 connection slave;
14 CREATE TRIGGER tr_ins BEFORE INSERT ON t1 FOR EACH ROW BEGIN
15 DECLARE a INT;
16 SET a = db2.get_value(1);
17 END//
18 connection master;
19 INSERT INTO t1 VALUES (1);
20 connection slave;
21 connection slave;
22 DROP TRIGGER tr_ins;
23 #
24 # Test Update_rows_log_event
25 connection master;
26 INSERT INTO t1 VALUES (5);
27 connection slave;
28 connection slave;
29 CREATE TRIGGER tr_upd BEFORE UPDATE ON t1 FOR EACH ROW BEGIN
30 DECLARE a INT;
31 SET a = db2.get_value(1);
32 END//
33 connection master;
34 UPDATE t1 SET a=a+1 WHERE a=5;
35 connection slave;
36 connection slave;
37 DROP TRIGGER tr_upd;
38 #
39 # Test Delete_rows_log_event
40 connection master;
41 INSERT INTO t1 VALUES (7);
42 connection slave;
43 connection slave;
44 CREATE TRIGGER tr_del BEFORE DELETE ON t1 FOR EACH ROW BEGIN
45 DECLARE a INT;
46 SET a = db2.get_value(1);
47 END//
48 connection master;
49 DELETE FROM t1 WHERE a=7;
50 connection slave;
51 connection slave;
52 DROP TRIGGER tr_del;
53 #
54 # Cleanup
55 connection slave;
56 SET GLOBAL slave_run_triggers_for_rbr=NO;
57 DROP DATABASE db2;
58 connection master;
59 DROP TABLE t1;
60 include/rpl_end.inc