diff options
Diffstat (limited to 'mysql-test/r/partition_cache.result')
| -rw-r--r-- | mysql-test/r/partition_cache.result | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/mysql-test/r/partition_cache.result b/mysql-test/r/partition_cache.result index 39ba4841337..697ba1bcd15 100644 --- a/mysql-test/r/partition_cache.result +++ b/mysql-test/r/partition_cache.result @@ -113,9 +113,10 @@ select count(*) from t1; count(*) 1 drop table t1; +connect connection1,localhost,root,,; SET SESSION STORAGE_ENGINE = InnoDB; SET @@autocommit=1; -connection default +connection default; SHOW VARIABLES LIKE 'have_query_cache'; Variable_name Value have_query_cache YES @@ -137,7 +138,7 @@ count(*) show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 -connection connection1 +connection connection1; START TRANSACTION; SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) @@ -153,7 +154,7 @@ count(*) show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 -connection default +connection default; SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) 1 @@ -167,7 +168,7 @@ count(*) show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 -connection connection1 +connection connection1; SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) 2 @@ -179,7 +180,7 @@ INSERT INTO t2 VALUES (6,'w'); SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) 3 -connection default +connection default; SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) 2 @@ -192,7 +193,7 @@ SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) 1 COMMIT; -connection connection1 +connection connection1; COMMIT; SELECT sql_cache count(*) FROM t2 WHERE s2 = 'w'; count(*) @@ -203,6 +204,8 @@ Qcache_queries_in_cache 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 +disconnect connection1; +connection default; set @@global.query_cache_size = @save_query_cache_size; drop table t2; SET global query_cache_type=default; |