Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP TABLE IF EXISTS test.t1;
6 DROP TABLE IF EXISTS test.t2;
7 CREATE TABLE test.t1 (a INT, PRIMARY KEY(a));
8 INSERT INTO test.t1 VALUES (1),(2),(3),(4);
9 CREATE TABLE test.t2 (a INT, PRIMARY KEY(a));
10 CREATE PROCEDURE test.p1 (arg1 CHAR(1))
11 BEGIN
12 DECLARE b, c INT;
13 IF arg1 = 'a' THEN
14 BEGIN
15 DECLARE cur1 CURSOR FOR SELECT A FROM test.t1 WHERE a % 2;
16 DECLARE continue handler for not found set b = 1;
17 SET b = 0;
18 OPEN cur1;
19 c1_repeat: REPEAT
20 FETCH cur1 INTO c;
21 IF (b = 1) THEN
22 LEAVE c1_repeat;
23 END IF;
24 INSERT INTO test.t2 VALUES (c);
25 UNTIL b = 1
26 END REPEAT;
27 CLOSE cur1;
28 END;
29 END IF;
30 IF arg1 = 'b' THEN
31 BEGIN
32 DECLARE cur2 CURSOR FOR SELECT a FROM test.t1 WHERE NOT a % 2;
33 DECLARE continue handler for not found set b = 1;
34 SET b = 0;
35 OPEN cur2;
36 c2_repeat: REPEAT
37 FETCH cur2 INTO c;
38 IF (b = 1) THEN
39 LEAVE c2_repeat;
40 END IF;
41 INSERT INTO test.t2 VALUES (c);
42 UNTIL b = 1
43 END REPEAT;
44 CLOSE cur2;
45 END;
46 END IF;
47 END|
48 CALL test.p1('a');
49 SELECT * FROM test.t2 ORDER BY a;
50 a
51 1
52 3
53 connection slave;
54 SELECT * FROM test.t2 ORDER BY a;
55 a
56 1
57 3
58 connection master;
59 truncate test.t2;
60 call test.p1('b');
61 select * from test.t2 ORDER BY a;
62 a
63 2
64 4
65 connection slave;
66 SELECT * FROM test.t2 ORDER BY a;
67 a
68 2
69 4
70 connection master;
71 truncate test.t2;
72 SELECT * FROM test.t2 ORDER BY a;
73 a
74 connection slave;
75 SELECT * FROM test.t2 ORDER BY a;
76 a
77 connection master;
78 DROP PROCEDURE test.p1;
79 DROP TABLE test.t1;
80 DROP TABLE test.t2;
81 connection slave;
82 include/rpl_end.inc