From 645d19f694c1237d4c9d34475dcbdc541e9f35d6 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 22 Mar 2004 14:44:41 +0100 Subject: WL#1366: Use the schema (db) associated with an SP. Phase 4 (final): Remove associated stored procedures when a database is dropped. mysql-test/r/sp-security.result: drop database now deletes associated SPs. mysql-test/r/sp.result: drop database now deletes associated SPs. mysql-test/t/sp-security.test: drop database now deletes associated SPs. mysql-test/t/sp.test: drop database now deletes associated SPs. sql/sp.cc: New function for deleting all SPs associated with a database. sql/sp.h: New function for deleting all SPs associated with a database. sql/sp_cache.cc: New function for just invalidating all SP caches (when dropping a database). sql/sp_cache.h: New function for just invalidating all SP caches (when dropping a database). sql/sql_db.cc: When dropping a database, also delete all associated SPs. --- sql/sp_cache.h | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sql/sp_cache.h') diff --git a/sql/sp_cache.h b/sql/sp_cache.h index 253e9b11588..754a987090e 100644 --- a/sql/sp_cache.h +++ b/sql/sp_cache.h @@ -40,6 +40,9 @@ sp_head *sp_cache_lookup(sp_cache **cp, sp_name *name); /* Remove an SP from cache. Returns true if something was removed */ bool sp_cache_remove(sp_cache **cp, sp_name *name); +/* Invalidate a cache */ +void sp_cache_invalidate(); + /* * -- cgit v1.2.1