summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_cache.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/subselect_cache.result')
-rw-r--r--mysql-test/r/subselect_cache.result22
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/r/subselect_cache.result b/mysql-test/r/subselect_cache.result
index 813d668c88c..6904d4a5889 100644
--- a/mysql-test/r/subselect_cache.result
+++ b/mysql-test/r/subselect_cache.result
@@ -2014,19 +2014,19 @@ flush status;
select * from t1 where a in (select pk from t2);
a b
0 0
-1 1
-2 2
0 0
-1 1
-2 2
0 0
-1 1
-2 2
0 0
-1 1
-2 2
0 0
1 1
+1 1
+1 1
+1 1
+1 1
+2 2
+2 2
+2 2
+2 2
2 2
show status like "subquery_cache%";
Variable_name Value
@@ -2034,10 +2034,10 @@ Subquery_cache_hit 0
Subquery_cache_miss 0
show status like '%Handler_read%';
Variable_name Value
-Handler_read_first 0
-Handler_read_key 15
+Handler_read_first 1
+Handler_read_key 0
Handler_read_last 0
-Handler_read_next 0
+Handler_read_next 10
Handler_read_prev 0
Handler_read_retry 0
Handler_read_rnd 0