diff options
| author | malff@lambda.hsd1.co.comcast.net. <> | 2008-03-25 11:20:11 -0600 |
|---|---|---|
| committer | malff@lambda.hsd1.co.comcast.net. <> | 2008-03-25 11:20:11 -0600 |
| commit | 0a2e401c0a99fad0c62c5c6b308db744d3146d40 (patch) | |
| tree | 2114c2ae14cfd3b0af762ba96484d1546ef5f30c /mysql-test/t/sp-code.test | |
| parent | 1eb00401f4e46b555cdbf906cc468d152be563c2 (diff) | |
| download | mariadb-git-0a2e401c0a99fad0c62c5c6b308db744d3146d40.tar.gz | |
Bug#20906 (Multiple assignments in SET in stored routine produce incorrect
instructions)
This bug can not be reproduced in the current version,
adding the test case to the test suite for coverage, no code change.
Diffstat (limited to 'mysql-test/t/sp-code.test')
| -rw-r--r-- | mysql-test/t/sp-code.test | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/t/sp-code.test b/mysql-test/t/sp-code.test index 751282c895a..a76863dd5fa 100644 --- a/mysql-test/t/sp-code.test +++ b/mysql-test/t/sp-code.test @@ -598,4 +598,36 @@ show procedure code proc_33618_c; drop procedure proc_33618_h; drop procedure proc_33618_c; +# +# Bug#20906 (Multiple assignments in SET in stored routine produce incorrect +# instructions) +# + +--disable_warnings +drop procedure if exists p_20906_a; +drop procedure if exists p_20906_b; +--enable_warnings + +create procedure p_20906_a() SET @a=@a+1, @b=@b+1; +show procedure code p_20906_a; + +set @a=1; +set @b=1; + +call p_20906_a(); +select @a, @b; + +create procedure p_20906_b() SET @a=@a+1, @b=@b+1, @c=@c+1; +show procedure code p_20906_b; + +set @a=1; +set @b=1; +set @c=1; + +call p_20906_b(); +select @a, @b, @c; + +drop procedure p_20906_a; +drop procedure p_20906_b; + --echo End of 5.0 tests. |