diff options
| author | unknown <sergefp@mysql.com> | 2005-08-10 21:17:02 +0000 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-08-10 21:17:02 +0000 |
| commit | 6b9ec78be00d37b91d4de8564bc0103d83ddfb26 (patch) | |
| tree | 5dab1a0ca73f1e4942bf33d79a0b027bc008ab28 /mysql-test/r/sp-threads.result | |
| parent | 08cadd816e7fd92f6f56c3ba621aa81d47954fca (diff) | |
| download | mariadb-git-6b9ec78be00d37b91d4de8564bc0103d83ddfb26.tar.gz | |
BUG#12228: Post review fixes: Added test case, code cleanup.
mysql-test/r/sp-threads.result:
Testcase for BUG#12228
mysql-test/t/sp-threads.test:
Testcase for BUG#12228
sql/sp_cache.cc:
BUG#12228: Post-review fixes: small code cleanup
sql/sp_cache.h:
BUG#12228: Post-review fixes: fixed the comment
sql/sql_parse.cc:
BUG#12228: Post-review fixes: in mysql_parse, flush obsolete SPs from the caches only if
the query hasn't been handled by the query cache.
sql/sql_prepare.cc:
BUG#12228: Post-review fixes: in mysql_stmt_prepare/execute, flush SP caches
"closer to the execution"
Diffstat (limited to 'mysql-test/r/sp-threads.result')
| -rw-r--r-- | mysql-test/r/sp-threads.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/sp-threads.result b/mysql-test/r/sp-threads.result index 2f7e8021aa7..c516d7a643f 100644 --- a/mysql-test/r/sp-threads.result +++ b/mysql-test/r/sp-threads.result @@ -37,6 +37,7 @@ Id User Host db Command Time State Info # root localhost test Sleep # NULL # root localhost test Query # Locked update t1, t2 set val= 1 where id1=id2 # root localhost test Query # NULL show processlist +# root localhost test Sleep # NULL unlock tables; drop procedure bug9486; drop table t1, t2; @@ -64,3 +65,27 @@ insert into t1 (select f from v1); drop function bug11554; drop table t1; drop view v1; +drop procedure if exists p1; +drop procedure if exists p2; +create table t1 (s1 int)| +create procedure p1() select * from t1| +create procedure p2() +begin +insert into t1 values (1); +call p1(); +select * from t1; +end| +use test; +lock table t1 write; + call p2(); +use test; +drop procedure p1; +create procedure p1() select * from t1; +unlock tables; +s1 +1 +s1 +1 +drop procedure p1; +drop procedure p2; +drop table t1; |