diff options
author | unknown <bell@sanja.is.com.ua> | 2002-10-08 00:26:15 +0300 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2002-10-08 00:26:15 +0300 |
commit | da4d15312446b151e7225434734246f1e5538118 (patch) | |
tree | 1f656592d377f96fbe4e104ca29476b1bc3f5a71 /mysql-test | |
parent | a30eaeb08361be650e0d7f6dc544fb71f7b73680 (diff) | |
download | mariadb-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.result | 10 | ||||
-rw-r--r-- | mysql-test/t/query_cache.test | 14 |
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"; |