diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-07-04 01:36:06 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-07-04 01:36:06 +0300 |
| commit | b17793f5b554f6d78ab279507aa5937a1ee13432 (patch) | |
| tree | c6239cbad5b2c45b632a26394a87222810120e4d /mysql-test/r/query_cache.result | |
| parent | e45709dfbdb7e834fc46fa8c112452ac9218b9f7 (diff) | |
| parent | 0cc6dd83c469b105c6c4e9032d28b01dd208c532 (diff) | |
| download | mariadb-git-b17793f5b554f6d78ab279507aa5937a1ee13432.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/query_cache.result')
| -rw-r--r-- | mysql-test/r/query_cache.result | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index a60b3cdbb1b..3af0d4c3704 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -1006,4 +1006,57 @@ show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 drop table t1; +create table t1 (a int); +insert into t1 values (1); +reset query cache; +flush status; +select * from (select * from t1) a; +a +1 +show status like "Qcache_queries_in_cache"; +Variable_name Value +Qcache_queries_in_cache 1 +show status like "Qcache_inserts"; +Variable_name Value +Qcache_inserts 1 +show status like "Qcache_hits"; +Variable_name Value +Qcache_hits 0 +select * from (select * from t1) a; +a +1 +show status like "Qcache_queries_in_cache"; +Variable_name Value +Qcache_queries_in_cache 1 +show status like "Qcache_inserts"; +Variable_name Value +Qcache_inserts 1 +show status like "Qcache_hits"; +Variable_name Value +Qcache_hits 1 +insert into t1 values (2); +show status like "Qcache_queries_in_cache"; +Variable_name Value +Qcache_queries_in_cache 0 +show status like "Qcache_inserts"; +Variable_name Value +Qcache_inserts 1 +show status like "Qcache_hits"; +Variable_name Value +Qcache_hits 1 +select * from (select * from t1) a; +a +1 +2 +show status like "Qcache_queries_in_cache"; +Variable_name Value +Qcache_queries_in_cache 1 +show status like "Qcache_inserts"; +Variable_name Value +Qcache_inserts 2 +show status like "Qcache_hits"; +Variable_name Value +Qcache_hits 1 + +drop table t1; set GLOBAL query_cache_size=0; |