diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/sp.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/sp.test | 12 |
2 files changed, 22 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; diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index abd3901f234..af481258b3d 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -1444,3 +1444,15 @@ drop procedure bar| delimiter ;| drop table t1; drop table t2; + +# +# rexecution +# +create procedure p1 () select (select s1 from t1) from t1; +create table t1 (s1 int); +call p1(); +insert into t1 values (1); +call p1(); +drop procedure p1; +drop table t1; + |