diff options
| author | Alexander Nozdrin <alexander.nozdrin@oracle.com> | 2011-03-10 11:07:57 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alexander.nozdrin@oracle.com> | 2011-03-10 11:07:57 +0300 |
| commit | 5653a71d3ec08e64098b430fcd7def790e249fa3 (patch) | |
| tree | 5fa3a4d25f85e9fca1dd6180886d6e2bd4399afb /mysql-test/t/trigger.test | |
| parent | 0b7e6f81afe24f4734b3d8ce5d85411609f8d3a0 (diff) | |
| download | mariadb-git-5653a71d3ec08e64098b430fcd7def790e249fa3.tar.gz | |
Patch for Bug#11765684 (58674: SP-cache does not detect changes in
pre-locking list caused by triggers).
The thing is that CREATE TRIGGER / DROP TRIGGER may actually
change pre-locking list of (some) stored routines.
The SP-cache does not detect such changes. Thus if sp_head-instance
is cached in SP-cache, subsequent executions of the cached
sp_head will use inaccurate pre-locking list.
The patch is to invalidate SP-cache on CREATE TRIGGER / DROP TRIGGER.
Diffstat (limited to 'mysql-test/t/trigger.test')
| -rw-r--r-- | mysql-test/t/trigger.test | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test index 3e4c3660f88..e5039c3ea23 100644 --- a/mysql-test/t/trigger.test +++ b/mysql-test/t/trigger.test @@ -998,10 +998,6 @@ call p1(); drop trigger t1_bi; create trigger t1_bi after insert on t1 for each row insert into t3 values (new.id); execute stmt1; -# Until we implement proper mechanism for invalidation of SP statements -# invoked whenever a table used in SP changes, this statement will fail with -# 'Table ... does not exist' error. ---error ER_NO_SUCH_TABLE call p1(); deallocate prepare stmt1; drop procedure p1; |