From 5cd5ee5f1c3f3d268d508bbe82e9e0e6d2143899 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 20 Nov 2003 18:12:49 +0200 Subject: database invalidation invalidate queries only of given database (BUG#1898) mysql-test/r/query_cache.result: test of drop database mysql-test/t/query_cache.test: test of drop database sql/sql_cache.cc: database invalidation invalidate queries only of given database every freed block header marked as FREE even if it will be merged to make moving & deleting tables block safe layout fixed (too long line) --- mysql-test/t/query_cache.test | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/t/query_cache.test') diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index 2ab5504f84b..ad0dc80e2f7 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -251,10 +251,14 @@ select * from mysqltest.t1 where i is null; # # drop db # +create table t1(a int); +select * from t1; +show status like "Qcache_queries_in_cache"; select * from mysqltest.t1; show status like "Qcache_queries_in_cache"; drop database mysqltest; show status like "Qcache_queries_in_cache"; +drop table t1; # # Charset convertion (cp1251_koi8 always present) -- cgit v1.2.1