diff options
Diffstat (limited to 'mysql-test/r/query_cache_ps_ps_prot.result')
| -rw-r--r-- | mysql-test/r/query_cache_ps_ps_prot.result | 46 |
1 files changed, 23 insertions, 23 deletions
diff --git a/mysql-test/r/query_cache_ps_ps_prot.result b/mysql-test/r/query_cache_ps_ps_prot.result index 4105bc40f94..e3f2da1dbbe 100644 --- a/mysql-test/r/query_cache_ps_ps_prot.result +++ b/mysql-test/r/query_cache_ps_ps_prot.result @@ -1,7 +1,7 @@ set GLOBAL query_cache_type=ON; set LOCAL query_cache_type=ON; ----- establish connection con1 (root) ---- ----- switch to connection default ---- +connect con1,localhost,root,,test,$MASTER_MYPORT,; +connection default; set @initial_query_cache_size = @@global.query_cache_size; set @@global.query_cache_size=102400; flush status; @@ -49,7 +49,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 5 ----- switch to connection con1 ---- +connection con1; prepare stmt3 from "select * from t1 where c1=10"; execute stmt3; c1 @@ -69,7 +69,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 8 ----- switch to connection default ---- +connection default; prepare stmt10 from "SELECT * FROM t1 WHERE c1 = 100"; show status like 'Qcache_hits'; Variable_name Value @@ -92,18 +92,18 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 9 ----- switch to connection con1 ---- +connection con1; SELECT * FROM t1 WHERE c1 = 100; c1 100 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 10 ----- switch to connection default ---- +connection default; prepare stmt11 from "SELECT * FROM t1 WHERE c1 = 1"; ----- switch to connection con1 ---- +connection con1; prepare stmt12 from "SELECT * FROM t1 WHERE c1 = 1"; ----- switch to connection default ---- +connection default; SELECT * FROM t1 WHERE c1 = 1; c1 1 @@ -122,14 +122,14 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 11 ----- switch to connection con1 ---- +connection con1; execute stmt12; c1 1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 12 ----- switch to connection default ---- +connection default; prepare stmt1 from "select * from t1 where c1=?"; show status like 'Qcache_hits'; Variable_name Value @@ -147,7 +147,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 13 ----- switch to connection con1 ---- +connection con1; set @a=1; prepare stmt4 from "select * from t1 where c1=?"; execute stmt4 using @a; @@ -169,7 +169,7 @@ execute stmt4 using @a; show status like 'Qcache_hits'; Variable_name Value Qcache_hits 14 ----- switch to connection default ---- +connection default; prepare stmt1 from "select * from t1 where c1=10"; set global query_cache_size=0; show status like 'Qcache_hits'; @@ -193,7 +193,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 14 ----- switch to connection con1 ---- +connection con1; execute stmt3; c1 10 @@ -212,7 +212,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 14 ----- switch to connection default ---- +connection default; set global query_cache_size=102400; execute stmt1; c1 @@ -232,7 +232,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 16 ----- switch to connection con1 ---- +connection con1; execute stmt3; c1 10 @@ -251,7 +251,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 ----- switch to connection default ---- +connection default; set global query_cache_size=0; show status like 'Qcache_hits'; Variable_name Value @@ -274,7 +274,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 ----- switch to connection con1 ---- +connection con1; execute stmt3; c1 10 @@ -293,12 +293,12 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 ----- switch to connection default ---- +connection default; set global query_cache_size=0; prepare stmt1 from "select * from t1 where c1=10"; ----- switch to connection con1 ---- +connection con1; prepare stmt3 from "select * from t1 where c1=10"; ----- switch to connection default ---- +connection default; set global query_cache_size=102400; show status like 'Qcache_hits'; Variable_name Value @@ -321,7 +321,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 ----- switch to connection con1 ---- +connection con1; show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 @@ -343,7 +343,7 @@ c1 show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 ----- switch to connection default ---- +connection default; set global query_cache_size=0; prepare stmt1 from "select * from t1 where c1=?"; set global query_cache_size=102400; @@ -372,7 +372,7 @@ show status like 'Qcache_hits'; Variable_name Value Qcache_hits 19 drop table t1; ----- disconnect connection con1 ---- +disconnect con1; ######################################################################## # # BUG#25843: Changing default database between PREPARE and EXECUTE of |