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