Debian Codegraph @

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

raw
1 --source include/master-slave.inc
2
3 connection master;
4 CREATE TABLE t1 (id INT);
5 DELIMITER $$;
6 CREATE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
7 DELIMITER ;$$
8 CALL proc1(@cnt);
9 SELECT @cnt;
10 INSERT INTO t1 VALUES (1), (2), (3);
11 CALL proc1(@cnt);
12 SELECT @cnt;
13
14 --echo # Syncing with slave
15 sync_slave_with_master;
16
17 CALL proc1(@cnt);
18 SELECT @cnt;
19
20 connection master;
21 DELIMITER $$;
22 --error ER_SP_ALREADY_EXISTS
23 CREATE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
24
25 CREATE PROCEDURE IF NOT EXISTS proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
26
27 --error ER_WRONG_USAGE
28 CREATE OR REPLACE PROCEDURE IF NOT EXISTS proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
29
30 CREATE OR REPLACE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
31 DELIMITER ;$$
32
33 --echo # Syncing with slave
34 sync_slave_with_master;
35
36 CALL proc1(@cnt);
37 SELECT @cnt;
38
39 connection master;
40 DROP PROCEDURE proc1;
41 DELIMITER $$;
42 CREATE PROCEDURE IF NOT EXISTS proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
43 DELIMITER ;$$
44 INSERT INTO t1 VALUES (1), (2), (3);
45 CALL proc1(@cnt);
46 SELECT @cnt;
47
48 --echo # Syncing with slave
49 sync_slave_with_master;
50
51 CALL proc1(@cnt);
52 SELECT @cnt;
53
54 connection master;
55 DROP PROCEDURE proc1;
56 DELIMITER $$;
57 CREATE OR REPLACE PROCEDURE proc1 (OUT cnt INT) BEGIN SELECT COUNT(*) INTO cnt FROM t1; END$$
58 DELIMITER ;$$
59 INSERT INTO t1 VALUES (1), (2), (3);
60 CALL proc1(@cnt);
61 SELECT @cnt;
62
63 --echo # Syncing with slave
64 sync_slave_with_master;
65
66 CALL proc1(@cnt);
67 SELECT @cnt;
68
69 connection master;
70 DROP TABLE IF EXISTS t1;
71 DROP PROCEDURE proc1;
72
73 DROP PROCEDURE IF EXISTS proc2;
74
75 --echo # Syncing with slave
76 sync_slave_with_master;
77
78 --error ER_SP_DOES_NOT_EXIST
79 DROP PROCEDURE proc1;
80
81 --source include/rpl_end.inc