Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_sp004.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 TABLE IF EXISTS test.t2;
7 DROP TABLE IF EXISTS test.t1;
8 DROP TABLE IF EXISTS test.t3;
9 CREATE PROCEDURE test.p1()
10 BEGIN
11 CREATE TABLE IF NOT EXISTS test.t1(a INT,PRIMARY KEY(a));
12 CREATE TABLE IF NOT EXISTS test.t2(a INT,PRIMARY KEY(a));
13 INSERT INTO test.t1 VALUES (4),(2),(1),(3);
14 UPDATE test.t1 SET a=a+4 WHERE a=4;
15 INSERT INTO test.t2 (a) SELECT t1.a FROM test.t1;
16 UPDATE test.t1 SET a=a+4 WHERE a=8;
17 CREATE TABLE IF NOT EXISTS test.t3(n MEDIUMINT NOT NULL AUTO_INCREMENT, f FLOAT, d DATETIME, PRIMARY KEY(n));
18 END|
19 CREATE PROCEDURE test.p2()
20 BEGIN
21 DROP TABLE IF EXISTS test.t1;
22 DROP TABLE IF EXISTS test.t2;
23 INSERT INTO test.t3 VALUES(NULL,11111111.233333,NOW());
24 END|
25 CALL test.p1();
26 SELECT * FROM test.t1 ORDER BY a;
27 a
28 1
29 2
30 3
31 12
32 SELECT * FROM test.t2 ORDER BY a;
33 a
34 1
35 2
36 3
37 8
38 connection slave;
39 SELECT * FROM test.t1 ORDER BY a;
40 a
41 1
42 2
43 3
44 12
45 SELECT * FROM test.t2 ORDER BY a;
46 a
47 1
48 2
49 3
50 8
51 connection master;
52 CALL test.p2();
53 USE test;
54 SHOW TABLES;
55 Tables_in_test
56 t3
57 connection slave;
58 USE test;
59 SHOW TABLES;
60 Tables_in_test
61 t3
62 connection master;
63 CALL test.p1();
64 Warnings:
65 Note 1050 Table 't3' already exists
66 SELECT * FROM test.t1 ORDER BY a;
67 a
68 1
69 2
70 3
71 12
72 SELECT * FROM test.t2 ORDER BY a;
73 a
74 1
75 2
76 3
77 8
78 connection slave;
79 SELECT * FROM test.t1 ORDER BY a;
80 a
81 1
82 2
83 3
84 12
85 SELECT * FROM test.t2 ORDER BY a;
86 a
87 1
88 2
89 3
90 8
91 connection master;
92 DROP PROCEDURE IF EXISTS test.p1;
93 DROP PROCEDURE IF EXISTS test.p2;
94 DROP TABLE IF EXISTS test.t1;
95 DROP TABLE IF EXISTS test.t2;
96 DROP TABLE IF EXISTS test.t3;
97 connection slave;
98 include/rpl_end.inc