summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp.result
diff options
context:
space:
mode:
authorunknown <kaa@polly.local>2006-12-15 13:23:05 +0300
committerunknown <kaa@polly.local>2006-12-15 13:23:05 +0300
commit36c0cc54b3b91566bb18ce29e74aaa0f76b77cbf (patch)
treec30d3430db233568707e5e909382ee6d594c8f58 /mysql-test/r/sp.result
parent501f92474e27c427ae971b736401f4368e93b36d (diff)
parent3863e8d643fe0e7af45a406c78000d30d1b011fb (diff)
downloadmariadb-git-36c0cc54b3b91566bb18ce29e74aaa0f76b77cbf.tar.gz
Merge polly.local:/tmp/maint/bug24117/my51-bug24117
into polly.local:/home/kaa/src/maint/mysql-5.1-maint mysql-test/r/sp.result: Auto merged mysql-test/t/sp.test: Auto merged mysys/typelib.c: Auto merged sql/field.cc: Auto merged sql/field.h: Auto merged
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r--mysql-test/r/sp.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result
index 6859de2ed63..fb2e456833c 100644
--- a/mysql-test/r/sp.result
+++ b/mysql-test/r/sp.result
@@ -5816,4 +5816,20 @@ DROP TABLE bug23760, bug23760_log|
DROP PROCEDURE bug23760_update_log|
DROP PROCEDURE bug23760_test_row_count|
DROP FUNCTION bug23760_rc_test|
+DROP PROCEDURE IF EXISTS bug24117|
+DROP TABLE IF EXISTS t3|
+CREATE TABLE t3(c1 ENUM('abc'))|
+INSERT INTO t3 VALUES('abc')|
+CREATE PROCEDURE bug24117()
+BEGIN
+DECLARE t3c1 ENUM('abc');
+DECLARE mycursor CURSOR FOR SELECT c1 FROM t3;
+OPEN mycursor;
+FLUSH TABLES;
+FETCH mycursor INTO t3c1;
+CLOSE mycursor;
+END|
+CALL bug24117()|
+DROP PROCEDURE bug24117|
+DROP TABLE t3|
drop table t1,t2;