On 2/24/11 10:05 AM, Alexander Nozdrin wrote:
> #Atfile:///home/alik/MySQL/bzr/00/bug58674/mysql-5.5-bug58674/ based
> 3357 Alexander Nozdrin 2011-02-24
> Patch for Bug#11765684 (58674: SP-cache does not detect changes in
> --echo # -- 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.
OK to push.