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/r/sp.result | |
| 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/r/sp.result')
| -rw-r--r-- | mysql-test/r/sp.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 4052cd58c0f..6b58b939a07 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -6820,6 +6820,24 @@ ttt 2 drop function func30787; drop table t1; +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(); +id +1 +2 +3 +4 +CALL test_sp(); +id +1 +2 +3 +4 +DROP PROCEDURE test_sp; +DROP TABLE t1; create table t1(c1 INT); create function f1(p1 int) returns varchar(32) return 'aaa'; |