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