Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_sp008.result

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