summaryrefslogtreecommitdiff
path: root/mysql-test/r/join_cache.result
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-04-17 20:25:03 +0200
committerSergei Golubchik <sergii@pisem.net>2012-04-17 20:25:03 +0200
commit580eca69ae0fd5186231ef318964349ffff6c499 (patch)
tree6bbe7033503fd3f46af32e3316dfb9c675b0a091 /mysql-test/r/join_cache.result
parent81e3e7d4a26363153ba6e0877053ed0c2cf5a97a (diff)
downloadmariadb-git-580eca69ae0fd5186231ef318964349ffff6c499.tar.gz
typo fixed: space in the status variable name
Diffstat (limited to 'mysql-test/r/join_cache.result')
-rw-r--r--mysql-test/r/join_cache.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/join_cache.result b/mysql-test/r/join_cache.result
index fa8471eb1cb..0892ce7794a 100644
--- a/mysql-test/r/join_cache.result
+++ b/mysql-test/r/join_cache.result
@@ -3522,7 +3522,7 @@ id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t2 ref f1 f1 4 test.t1.f1 3 Using index condition(BKA); Using join buffer (flat, BKA join); Key-ordered Rowid-ordered scan
show status like "Handler_icp%";
Variable_name Value
-Handler_icp_attempts 20
+Handler_icp_attempts 20
Handler_icp_match 4
set join_cache_level=6;
select t2.f1, t2.f2, t2.f3 from t1,t2
@@ -3539,7 +3539,7 @@ id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t2 ref f1 f1 4 test.t1.f1 3 Using index condition(BKA); Using join buffer (flat, BKA join); Key-ordered Rowid-ordered scan
show status like "Handler_icp%";
Variable_name Value
-Handler_icp_attempts 40
+Handler_icp_attempts 40
Handler_icp_match 8
set join_cache_level=7;
select t2.f1, t2.f2, t2.f3 from t1,t2
@@ -3556,7 +3556,7 @@ id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t2 ref f1 f1 4 test.t1.f1 3 Using index condition(BKA); Using where; Using join buffer (flat, BKAH join); Key-ordered Rowid-ordered scan
show status like "Handler_icp%";
Variable_name Value
-Handler_icp_attempts 60
+Handler_icp_attempts 60
Handler_icp_match 12
set join_cache_level=8;
select t2.f1, t2.f2, t2.f3 from t1,t2
@@ -3573,7 +3573,7 @@ id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t2 ref f1 f1 4 test.t1.f1 3 Using index condition(BKA); Using where; Using join buffer (flat, BKAH join); Key-ordered Rowid-ordered scan
show status like "Handler_icp%";
Variable_name Value
-Handler_icp_attempts 80
+Handler_icp_attempts 80
Handler_icp_match 16
drop table t1,t2;
set join_cache_level=default;