Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_row_sp010.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP PROCEDURE IF EXISTS test.p2;
6 DROP PROCEDURE IF EXISTS test.p3;
7 DROP PROCEDURE IF EXISTS test.p4;
8 DROP TABLE IF EXISTS test.t1;
9 DROP TABLE IF EXISTS test.t2;
10 CREATE PROCEDURE test.p1()
11 BEGIN
12 INSERT INTO test.t1 VALUES(2);
13 END|
14 CREATE PROCEDURE test.p2()
15 BEGIN
16 DROP TEMPORARY TABLE IF EXISTS test.t1;
17 CREATE TEMPORARY TABLE test.t1 (a int, PRIMARY KEY(a));
18 INSERT INTO test.t1 VALUES(1);
19 CALL test.p1();
20 END|
21 CALL test.p2();
22 SELECT * FROM test.t1 ORDER BY a;
23 a
24 1
25 2
26 connection slave;
27 show tables;
28 Tables_in_test
29 connection master;
30 CREATE PROCEDURE test.p3()
31 BEGIN
32 INSERT INTO test.t2 VALUES(7);
33 END|
34 CREATE PROCEDURE test.p4()
35 BEGIN
36 DROP TABLE IF EXISTS test.t2;
37 CREATE TABLE test.t2 (a int, PRIMARY KEY(a));
38 INSERT INTO test.t2 VALUES(6);
39 CALL test.p3();
40 END|
41 CALL test.p4();
42 SELECT * FROM test.t2 ORDER BY a;
43 a
44 6
45 7
46 connection slave;
47 SELECT * FROM test.t2 ORDER BY a;
48 a
49 6
50 7
51 connection master;
52 DROP PROCEDURE IF EXISTS test.p1;
53 DROP PROCEDURE IF EXISTS test.p2;
54 DROP PROCEDURE IF EXISTS test.p3;
55 DROP PROCEDURE IF EXISTS test.p4;
56 DROP TABLE IF EXISTS test.t1;
57 DROP TABLE IF EXISTS test.t2;
58 connection slave;
59 include/rpl_end.inc