Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_trigger_multi_db.test

raw
1 #
2 # This test ensures that a table share's database name is not freed when
3 # using row based replication with triggers that open different databases
4 #
5 #
6 # References:
7 # MDEV-29894: Calling a function from a different database in a slave side
8 # trigger crashes
9 #
10 --source include/master-slave.inc
11 --source include/have_binlog_format_row.inc
12
13 --connection slave
14 --let $old_slave_run_triggers= `SELECT @@global.slave_run_triggers_for_rbr`
15 set global slave_run_triggers_for_rbr=1;
16
17 --connection master
18 CREATE TABLE t1 (a int);
19 --sync_slave_with_master
20
21 --connection slave
22 CREATE DATABASE db2;
23 CREATE FUNCTION db2.get_value(a INT) RETURNS int(2) RETURN 0;
24
25 --echo #
26 --echo # Test Insert_rows_log_event
27
28 --connection slave
29 DELIMITER //;
30 CREATE TRIGGER tr_ins BEFORE INSERT ON t1 FOR EACH ROW BEGIN
31 DECLARE a INT;
32 SET a = db2.get_value(1);
33 END//
34 DELIMITER ;//
35
36 --connection master
37 INSERT INTO t1 VALUES (1);
38 --sync_slave_with_master
39
40 --connection slave
41 DROP TRIGGER tr_ins;
42
43
44 --echo #
45 --echo # Test Update_rows_log_event
46 --connection master
47 --let $row_val=5
48 --eval INSERT INTO t1 VALUES ($row_val)
49 --sync_slave_with_master
50
51 --connection slave
52 DELIMITER //;
53 CREATE TRIGGER tr_upd BEFORE UPDATE ON t1 FOR EACH ROW BEGIN
54 DECLARE a INT;
55 SET a = db2.get_value(1);
56 END//
57 DELIMITER ;//
58
59 --connection master
60 --eval UPDATE t1 SET a=a+1 WHERE a=$row_val
61 --sync_slave_with_master
62
63 --connection slave
64 DROP TRIGGER tr_upd;
65
66
67 --echo #
68 --echo # Test Delete_rows_log_event
69 --connection master
70 --let $row_val=7
71 --eval INSERT INTO t1 VALUES ($row_val)
72 --sync_slave_with_master
73
74 --connection slave
75 DELIMITER //;
76 CREATE TRIGGER tr_del BEFORE DELETE ON t1 FOR EACH ROW BEGIN
77 DECLARE a INT;
78 SET a = db2.get_value(1);
79 END//
80 DELIMITER ;//
81
82 --connection master
83 --eval DELETE FROM t1 WHERE a=$row_val
84 --sync_slave_with_master
85
86 --connection slave
87 DROP TRIGGER tr_del;
88
89
90 --echo #
91 --echo # Cleanup
92 --connection slave
93 --eval SET GLOBAL slave_run_triggers_for_rbr=$old_slave_run_triggers
94 DROP DATABASE db2;
95 --connection master
96 DROP TABLE t1;
97
98 --source include/rpl_end.inc