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
15connection master;
16--disable_warnings
17DROP PROCEDURE IF EXISTS test.p1;
18DROP TABLE IF EXISTS test.t2;
19--enable_warnings
20# End of cleanup
21
22
23
24# Begin test section 1
25CREATE TABLE test.t1 (a INT,PRIMARY KEY(a));
26CREATE TABLE test.t2 (a INT,PRIMARY KEY(a));
27INSERT INTO test.t1 VALUES(1),(2);
28
29delimiter |;
30CREATE PROCEDURE test.p1()
31BEGIN
32 SELECT SQL_CALC_FOUND_ROWS * FROM test.t1 LIMIT 1;
33 INSERT INTO test.t2 VALUES(FOUND_ROWS());
34END|
35delimiter ;|
36
37CALL test.p1();
38SELECT * FROM test.t2;
39
40sync_slave_with_master;
41SELECT * FROM test.t2;
42
43# Cleanup
44
45connection master;
46DROP PROCEDURE IF EXISTS test.p1;
47DROP TABLE IF EXISTS test.t1;
48DROP TABLE IF EXISTS test.t2;
49sync_slave_with_master;
50
51# End of 5.0 test case
52--source include/rpl_end.inc
53