diff options
author | pem@mysql.comhem.se <> | 2004-09-02 17:24:25 +0200 |
---|---|---|
committer | pem@mysql.comhem.se <> | 2004-09-02 17:24:25 +0200 |
commit | fee115adca5b1f70ccf2d3d83920d742b66e2e73 (patch) | |
tree | cc966e471ebe1e3067e75ef8a5f30688101f8080 /mysql-test/r/sp.result | |
parent | 7ee2f2c6bba7561a51c72d51ad9374cbcf108109 (diff) | |
download | mariadb-git-fee115adca5b1f70ccf2d3d83920d742b66e2e73.tar.gz |
Fixed BUG#5287: Stored procedure crash if leave outside loop.
Bug in diff_handlers and diff_cursors made it attempt to pop
the wrong number at jumps sometimes.
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r-- | mysql-test/r/sp.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 9abb60634d9..8b20ae68dce 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1764,6 +1764,18 @@ call bug5251()| Table Checksum test.t1 0 drop procedure bug5251| +create procedure bug5287(param1 int) +label1: +begin +declare c cursor for select 5; +loop +if param1 >= 0 then +leave label1; +end if; +end loop; +end| +call bug5287(1)| +drop procedure bug5287| drop table if exists fac| create table fac (n int unsigned not null primary key, f bigint unsigned)| create procedure ifac(n int unsigned) |