diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-03-21 11:48:51 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-03-21 11:48:51 +0200 |
| commit | 91bac76e039a317858aa2dc95bcfc2475321fbfd (patch) | |
| tree | a1329b674e130295016f32bff9fcb79e31b36985 /mysql-test/t/grant_cache.test | |
| parent | 331ff0d8f5e092b9672f66d135d6209897b25846 (diff) | |
| download | mariadb-git-91bac76e039a317858aa2dc95bcfc2475321fbfd.tar.gz | |
fixed BUG in query cahe statistic counting
mysql-test/r/grant_cache.result:
right results in query cache
mysql-test/t/grant_cache.test:
proving new results
sql/sql_cache.cc:
fixed statistic calculating in query cahe
Diffstat (limited to 'mysql-test/t/grant_cache.test')
| -rw-r--r-- | mysql-test/t/grant_cache.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/grant_cache.test b/mysql-test/t/grant_cache.test index 95989d1ee99..f85584c3875 100644 --- a/mysql-test/t/grant_cache.test +++ b/mysql-test/t/grant_cache.test @@ -40,10 +40,22 @@ grant SELECT(a) on mysqltest.t1 to mysqltest_3@localhost; # The following queries should be fetched from cache connect (user1,localhost,mysqltest_1,,mysqltest,$MASTER_MYPORT,master.sock); connection user1; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +show status like "Qcache_not_cached"; select "user1"; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +show status like "Qcache_not_cached"; select * from t1; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +show status like "Qcache_not_cached"; # The pre and end space are intentional select a from t1 ; +show status like "Qcache_queries_in_cache"; +show status like "Qcache_hits"; +show status like "Qcache_not_cached"; select c from t1; show status like "Qcache_queries_in_cache"; show status like "Qcache_hits"; |