1include/master-slave.inc 2[connection master] 3connection master; 4DROP PROCEDURE IF EXISTS test.p1; 5DROP TABLE IF EXISTS test.t2; 6CREATE TABLE test.t1 (a INT,PRIMARY KEY(a)); 7CREATE TABLE test.t2 (a INT,PRIMARY KEY(a)); 8INSERT INTO test.t1 VALUES(1),(2); 9CREATE PROCEDURE test.p1() 10BEGIN 11SELECT SQL_CALC_FOUND_ROWS * FROM test.t1 LIMIT 1; 12INSERT INTO test.t2 VALUES(FOUND_ROWS()); 13END| 14CALL test.p1(); 15a 161 17SELECT * FROM test.t2; 18a 192 20connection slave; 21SELECT * FROM test.t2; 22a 232 24connection master; 25DROP PROCEDURE IF EXISTS test.p1; 26DROP TABLE IF EXISTS test.t1; 27DROP TABLE IF EXISTS test.t2; 28connection slave; 29include/rpl_end.inc 30