diff options
| author | Georgi Kodinov <kgeorge@mysql.com> | 2008-11-03 12:40:58 +0200 |
|---|---|---|
| committer | Georgi Kodinov <kgeorge@mysql.com> | 2008-11-03 12:40:58 +0200 |
| commit | 0d4aeaf6e3becb3bacb7ef8c8b168ec404abe936 (patch) | |
| tree | 4ec42cd7e4940d9951d522e4b544e099c56e1096 /mysql-test/t/sp.test | |
| parent | c82ff582226749c6049bdbbbdaa2031dc72d343b (diff) | |
| parent | 6af99825692914559fd88df5d3edf6d0dc83b73b (diff) | |
| download | mariadb-git-0d4aeaf6e3becb3bacb7ef8c8b168ec404abe936.tar.gz | |
merged 5.0 bug 33811 -> 5.1 bug 33811 working tree
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 632201a9e77..05bccae67aa 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -7997,8 +7997,24 @@ select (select func30787(f1)) as ttt from t1; drop function func30787; drop table t1; -########################################################################### +# +# Bug #33811: Call to stored procedure with SELECT * / RIGHT JOIN fails +# after the first time +# +CREATE TABLE t1 (id INT); +INSERT INTO t1 VALUES (1),(2),(3),(4); + +CREATE PROCEDURE test_sp() + SELECT t1.* FROM t1 RIGHT JOIN t1 t2 ON t1.id=t2.id; + +CALL test_sp(); +CALL test_sp(); +DROP PROCEDURE test_sp; +DROP TABLE t1; + + +########################################################################### # # Bug#38291 memory corruption and server crash with view/sp/function # |