diff options
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 12 |
1 files changed, 12 insertions, 0 deletions
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; + |