Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_sp008.test

raw
1 #############################################################################
2 # Original Author: JBM #
3 # Original Date: Aug/15/2005 #
4 # Update: 08/29/2005 Remove sleep #
5 #############################################################################
6 # TEST: Use SQL_CALC_FOUND_ROWS and insert results into a table inside a sp #
7 #############################################################################
8
9
10 # Includes
11 -- source include/have_binlog_format_row.inc
12 -- source include/master-slave.inc
13
14 # Begin clean up test section
15 connection master;
16 --disable_warnings
17 DROP PROCEDURE IF EXISTS test.p1;
18 DROP TABLE IF EXISTS test.t2;
19 --enable_warnings
20 # End of cleanup
21
22
23
24 # Begin test section 1
25 CREATE TABLE test.t1 (a INT,PRIMARY KEY(a));
26 CREATE TABLE test.t2 (a INT,PRIMARY KEY(a));
27 INSERT INTO test.t1 VALUES(1),(2);
28
29 delimiter |;
30 CREATE PROCEDURE test.p1()
31 BEGIN
32 SELECT SQL_CALC_FOUND_ROWS * FROM test.t1 LIMIT 1;
33 INSERT INTO test.t2 VALUES(FOUND_ROWS());
34 END|
35 delimiter ;|
36
37 CALL test.p1();
38 SELECT * FROM test.t2;
39
40 sync_slave_with_master;
41 SELECT * FROM test.t2;
42
43 # Cleanup
44
45 connection master;
46 DROP PROCEDURE IF EXISTS test.p1;
47 DROP TABLE IF EXISTS test.t1;
48 DROP TABLE IF EXISTS test.t2;
49 sync_slave_with_master;
50
51 # End of 5.0 test case
52 --source include/rpl_end.inc