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