Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE TABLE t1 (id INT);
5 CREATE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
6 CALL proc1(@cnt);
7 SELECT @cnt;
8 @cnt
9 0
10 INSERT INTO t1 VALUES (1), (2), (3);
11 CALL proc1(@cnt);
12 SELECT @cnt;
13 @cnt
14 3
15 # Syncing with slave
16 connection slave;
17 CALL proc1(@cnt);
18 SELECT @cnt;
19 @cnt
20 3
21 connection master;
22 CREATE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
23 ERROR 42000: PROCEDURE proc1 already exists
24 CREATE PROCEDURE IF NOT EXISTS proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
25 Warnings:
26 Note 1304 PROCEDURE proc1 already exists
27 CREATE OR REPLACE PROCEDURE IF NOT EXISTS proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
28 ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS
29 CREATE OR REPLACE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
30 # Syncing with slave
31 connection slave;
32 CALL proc1(@cnt);
33 SELECT @cnt;
34 @cnt
35 3
36 connection master;
37 DROP PROCEDURE proc1;
38 CREATE PROCEDURE IF NOT EXISTS proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
39 INSERT INTO t1 VALUES (1), (2), (3);
40 CALL proc1(@cnt);
41 SELECT @cnt;
42 @cnt
43 6
44 # Syncing with slave
45 connection slave;
46 CALL proc1(@cnt);
47 SELECT @cnt;
48 @cnt
49 6
50 connection master;
51 DROP PROCEDURE proc1;
52 CREATE OR REPLACE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
53 INSERT INTO t1 VALUES (1), (2), (3);
54 CALL proc1(@cnt);
55 SELECT @cnt;
56 @cnt
57 9
58 # Syncing with slave
59 connection slave;
60 CALL proc1(@cnt);
61 SELECT @cnt;
62 @cnt
63 9
64 connection master;
65 DROP TABLE IF EXISTS t1;
66 DROP PROCEDURE proc1;
67 DROP PROCEDURE IF EXISTS proc2;
68 Warnings:
69 Note 1305 PROCEDURE test.proc2 does not exist
70 # Syncing with slave
71 connection slave;
72 DROP PROCEDURE proc1;
73 ERROR 42000: PROCEDURE test.proc1 does not exist
74 include/rpl_end.inc