diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-19 19:58:27 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-11-19 20:22:33 +0200 |
| commit | dde2ca4aa108b611b5fdfc970146b28461ef08bf (patch) | |
| tree | 08f90bb9d54413af23230ccf99f18391596afa34 /mysql-test/main/sp-cursor.result | |
| parent | b5ac863f1494920b5e7035c9dfa0ebfdaa50a15d (diff) | |
| parent | fd58bb71e22196c3c5e8d20b92bce6f343f1dea1 (diff) | |
| download | mariadb-git-dde2ca4aa108b611b5fdfc970146b28461ef08bf.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/sp-cursor.result')
| -rw-r--r-- | mysql-test/main/sp-cursor.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/main/sp-cursor.result b/mysql-test/main/sp-cursor.result index f1dd8ed5eaa..42952be16e2 100644 --- a/mysql-test/main/sp-cursor.result +++ b/mysql-test/main/sp-cursor.result @@ -713,3 +713,27 @@ END; $$ CALL p1; DROP PROCEDURE p1; +# +# MDEV-17278 CURSOR FOR LOOP - ERROR: unexpected end of stream, read 0 bytes (SERVER CRASH) +# +CREATE TABLE t1 (id2 int, id int, en1 enum('aaa','a','b','c')); +INSERT INTO t1 VALUES(1,1,'aaa'),(2,2,'a'),(3,3,'b'),(4,4,'c'); +CREATE PROCEDURE p1() +BEGIN +FOR rec IN (SELECT en1 FROM t1) +DO +SELECT rec.en1; +END FOR; +END; +$$ +CALL p1(); +rec.en1 +aaa +rec.en1 +a +rec.en1 +b +rec.en1 +c +DROP PROCEDURE p1; +DROP TABLE t1; |