summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant_cache.test
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-03-29 19:21:53 +0300
committerunknown <monty@mysql.com>2004-03-29 19:21:53 +0300
commitff908d18a27247c3b4206ce49977c4a7c73792be (patch)
treef51ea3945f84d672edc962cdfc11eab16f569fc5 /mysql-test/t/grant_cache.test
parent883215956e1597c7432cb79a68b510a4c0f7c9c2 (diff)
parent501c3e7a0e1770aa7b40a2b1c19b8e89388b834f (diff)
downloadmariadb-git-ff908d18a27247c3b4206ce49977c4a7c73792be.tar.gz
Merge with 4.0 to get lastest bug fixes
include/m_string.h: Auto merged myisam/mi_create.c: Auto merged mysql-test/r/bdb-crash.result: Auto merged sql/handler.h: Auto merged mysql-test/r/grant_cache.result: Auto merged mysql-test/t/grant_cache.test: Auto merged sql/sql_cache.cc: Auto merged sql/sql_table.cc: Auto merged innobase/mem/mem0dbg.c: Merge with 4.0 mysql-test/r/myisam.result: Merge with 4.0 mysql-test/r/order_by.result: Merge with 4.0 mysql-test/t/bdb-crash.test: Merge with 4.0 mysql-test/t/myisam.test: Merge with 4.0 mysql-test/t/order_by.test: Merge with 4.0 sql/ha_berkeley.cc: Merge with 4.0 (use local code) sql/sql_select.cc: Merge with 4.0 to get fix for FORCE INDEX ... ORDER BY
Diffstat (limited to 'mysql-test/t/grant_cache.test')
-rw-r--r--mysql-test/t/grant_cache.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/grant_cache.test b/mysql-test/t/grant_cache.test
index 9ba845d6baa..5ebf621ff40 100644
--- a/mysql-test/t/grant_cache.test
+++ b/mysql-test/t/grant_cache.test
@@ -43,10 +43,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";