diff options
| author | dlenev@mysql.com <> | 2005-07-13 13:48:13 +0400 |
|---|---|---|
| committer | dlenev@mysql.com <> | 2005-07-13 13:48:13 +0400 |
| commit | f334ea1fc6f4e9e5be334f4f4c62a3b25c365426 (patch) | |
| tree | eb4e973833841f07d83fdb7e830b02e46a90b56a /mysql-test/r/sp-threads.result | |
| parent | f5f434cf9ff4a61c513a5f149801f84d8868671a (diff) | |
| download | mariadb-git-f334ea1fc6f4e9e5be334f4f4c62a3b25c365426.tar.gz | |
Implementation of Monty's idea: Now we can open mysql.proc table for lookup
of stored routines definitions even if we already have some tables open and
locked. To avoid deadlocks in this case we have to put certain restrictions
on locking of mysql.proc table.
This allows to use stored routines safely under LOCK TABLES without explicitly
mentioning mysql.proc in the list of locked tables. It also fixes bug #11554
"Server crashes on statement indirectly using non-cached function".
Diffstat (limited to 'mysql-test/r/sp-threads.result')
| -rw-r--r-- | mysql-test/r/sp-threads.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/sp-threads.result b/mysql-test/r/sp-threads.result index a9d50e6e697..e6b8128c336 100644 --- a/mysql-test/r/sp-threads.result +++ b/mysql-test/r/sp-threads.result @@ -55,3 +55,12 @@ call bug11158(); unlock tables; drop procedure bug11158; drop table t1, t2; +drop function if exists bug11554; +drop view if exists v1; +create table t1 (i int); +create function bug11554 () returns int return 1; +create view v1 as select bug11554() as f; +insert into t1 (select f from v1); +drop function bug11554; +drop table t1; +drop view v1; |