When you have a MySQL statement-based replication and you create a stored procedure that modify some rows (INSERT, UPDATE, DELETE commands...), What is really replicated on the slave when you call this procedure on the master ? The CALL himself or the commands (INSERT, UPDATE, DELETE...) inside the procedure ?
For example, create such a procedure:
delimiter | CREATE PROCEDURE myproc () BEGIN DELETE FROM mytable LIMIT 1; END | delimiter ;
Then call on the master:
master> CALL myproc();
=> does it replicates "CALL myproc()" or "DELETE FROM mytable LIMIT 1" ?