1 files changed, 56 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/t/sf_cursor.test b/mysql-test/suite/engines/funcs/t/sf_cursor.test
new file mode 100644
index 00000000000..c4b4ac33925
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/t/sf_cursor.test
@@ -0,0 +1,56 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1,t2,t3,t4;
+DROP FUNCTION IF EXISTS sf1;
+--enable_warnings
+CREATE TABLE t1 (id INTEGER NULL , data INTEGER NULL, KEY(id));
+CREATE TABLE t2 (i INTEGER NULL);
+CREATE TABLE t3 (id INTEGER NULL, data INTEGER NULL, KEY(id));
+CREATE TABLE t4 (i INTEGER NULL);
+INSERT INTO t1 VALUES(1,1),(2,1),(3,4),(4,5);
+INSERT INTO t2 VALUES(1),(2),(3);
+DELIMITER //;
+CREATE FUNCTION sf1() RETURNS INTEGER
+BEGIN
+DECLARE done INT DEFAULT 0;
+DECLARE a CHAR(16);
+DECLARE b,c INT;
+DECLARE cur1 CURSOR FOR SELECT id,data FROM t1;
+DECLARE cur2 CURSOR FOR SELECT i FROM t2;
+DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
+OPEN cur1;
+OPEN cur2;
+REPEAT
+FETCH cur1 INTO a, b;
+FETCH cur2 INTO c;
+IF NOT done THEN
+IF b < c THEN
+INSERT INTO t3 VALUES (a,b);
+ELSE
+INSERT INTO t3 VALUES (a,c);
+END IF;
+END IF;
+UNTIL done END REPEAT;
+CLOSE cur1;
+CLOSE cur2;
+RETURN 0;
+END//
+DELIMITER ;//
+SELECT sf1();
+SELECT * FROM t1 ORDER BY id;
+SELECT * FROM t2 ORDER BY i;
+SELECT * FROM t3 ORDER BY id;
+INSERT INTO t4 VALUES(sf1());
+SELECT * FROM t1 ORDER BY id;
+SELECT * FROM t2 ORDER BY i;
+SELECT * FROM t3 ORDER BY id;
+UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();
+SELECT * FROM t1 ORDER BY id;
+SELECT * FROM t2 ORDER BY i;
+SELECT * FROM t3 ORDER BY id;
+DELETE FROM t4 WHERE i = sf1() + 1;
+SELECT * FROM t1 ORDER BY id;
+SELECT * FROM t2 ORDER BY i;
+SELECT * FROM t3 ORDER BY id;
+DROP FUNCTION sf1;
+DROP TABLE t1,t2,t3,t4;
+