diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-11-20 18:12:49 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-11-20 18:12:49 +0200 |
| commit | 03e04c02cdf33c443db5b46b48f8c4ef02ad1b9e (patch) | |
| tree | 00ae1853b3692c50d3d0037e71afd411cf9ab8ed /mysql-test/t/query_cache.test | |
| parent | 24bdf9560396936bcdb540d785bcaf981b68d457 (diff) | |
| download | mariadb-git-03e04c02cdf33c443db5b46b48f8c4ef02ad1b9e.tar.gz | |
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)
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 4 |
1 files changed, 4 insertions, 0 deletions
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) |