diff options
| author | bell@sanja.is.com.ua <> | 2004-05-20 02:02:49 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-05-20 02:02:49 +0300 |
| commit | c7396f8d207510456e37143a3f3e1d0ae7c1a305 (patch) | |
| tree | de54f6ead302056d37992e52523ed0bec48700fc /mysql-test/r/sp.result | |
| parent | 9620715679e21196e087a57f10f42b974c281fe3 (diff) | |
| download | mariadb-git-c7396f8d207510456e37143a3f3e1d0ae7c1a305.tar.gz | |
PS and SP made compatible in mechanism used for preparing query for rexecutions (Bug #2266)
Diffstat (limited to 'mysql-test/r/sp.result')
| -rw-r--r-- | mysql-test/r/sp.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index cd5c2aa67c1..f8dcc114990 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1305,3 +1305,13 @@ test bar PROCEDURE root@localhost 0000-00-00 00:00:00 0000-00-00 00:00:00 DEFINE drop procedure bar| drop table t1; drop table t2; +create procedure p1 () select (select s1 from t1) from t1; +create table t1 (s1 int); +call p1(); +(select s1 from t1) +insert into t1 values (1); +call p1(); +(select s1 from t1) +1 +drop procedure p1; +drop table t1; |