summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2002-10-08 00:26:15 +0300
committerunknown <bell@sanja.is.com.ua>2002-10-08 00:26:15 +0300
commitda4d15312446b151e7225434734246f1e5538118 (patch)
tree1f656592d377f96fbe4e104ca29476b1bc3f5a71 /mysql-test
parenta30eaeb08361be650e0d7f6dc544fb71f7b73680 (diff)
downloadmariadb-git-da4d15312446b151e7225434734246f1e5538118.tar.gz
fixed query cache with system database
FN_NO_CASE_SENCE used instead of __WIN__ in table name handling of quary cache mysql-test/r/query_cache.result: query cache with system database test mysql-test/t/query_cache.test: query cache with system database test sql/sql_cache.cc: fixed query cache with system database FN_NO_CASE_SENCE used instead of __WIN__
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/query_cache.result10
-rw-r--r--mysql-test/t/query_cache.test14
2 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result
index 7c53074b6da..a09f4608142 100644
--- a/mysql-test/r/query_cache.result
+++ b/mysql-test/r/query_cache.result
@@ -526,3 +526,13 @@ show status like "Qcache_queries_in_cache";
Variable_name Value
Qcache_queries_in_cache 2
drop table t1, t2, t3;
+use mysql;
+select * from db;
+show status like "Qcache_queries_in_cache";
+Variable_name Value
+Qcache_queries_in_cache 0
+use test;
+select * from mysql.db;
+show status like "Qcache_queries_in_cache";
+Variable_name Value
+Qcache_queries_in_cache 0
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
index 5dc6d1047f4..a0d2a34ee76 100644
--- a/mysql-test/t/query_cache.test
+++ b/mysql-test/t/query_cache.test
@@ -367,3 +367,17 @@ show status like "Qcache_queries_in_cache";
select * from t3;
show status like "Qcache_queries_in_cache";
drop table t1, t2, t3;
+
+#
+# system databse test
+#
+use mysql;
+disable_result_log;
+select * from db;
+enable_result_log;
+show status like "Qcache_queries_in_cache";
+use test;
+disable_result_log;
+select * from mysql.db;
+enable_result_log;
+show status like "Qcache_queries_in_cache";