summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <sanja@montyprogram.com>2012-02-22 10:38:28 +0200
committerunknown <sanja@montyprogram.com>2012-02-22 10:38:28 +0200
commitc299e027eeddc35e0197ebc70805e0a303a4b135 (patch)
treefbe47b9e9d1fea8c0183950d63894d1774ad8a6a /mysql-test/r
parentc9fc9f73170a8eb16ea968a2ea51b298eb5cdcfc (diff)
downloadmariadb-git-c299e027eeddc35e0197ebc70805e0a303a4b135.tar.gz
Changed names of statistic variables and counting matches instaed of rejected rows.
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/innodb_icp.result18
-rw-r--r--mysql-test/r/join_cache.result24
-rw-r--r--mysql-test/r/maria_icp.result18
-rw-r--r--mysql-test/r/myisam_icp.result18
-rw-r--r--mysql-test/r/status.result8
-rw-r--r--mysql-test/r/status_user.result4
6 files changed, 45 insertions, 45 deletions
diff --git a/mysql-test/r/innodb_icp.result b/mysql-test/r/innodb_icp.result
index d8e41113f63..2817f83bed5 100644
--- a/mysql-test/r/innodb_icp.result
+++ b/mysql-test/r/innodb_icp.result
@@ -816,24 +816,24 @@ KEY (c1)
);
INSERT INTO t1 VALUES ('3', '3'),('4','4'),('5','5');
flush status;
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 0
-Handler_pushed_index_cond_filtered 0
+Handler_icp_attempts 0
+Handler_icp_match 0
SELECT * FROM t1 FORCE INDEX(c1) WHERE (c1='3' or c1='4') and c1 % 2 = 0 ;
c1 c2
4 4
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 2
-Handler_pushed_index_cond_filtered 1
+Handler_icp_attempts 2
+Handler_icp_match 1
SELECT * FROM t1 WHERE (c2='3' or c2='4') and c2 % 2 = 0 ;
c1 c2
4 4
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 2
-Handler_pushed_index_cond_filtered 1
+Handler_icp_attempts 2
+Handler_icp_match 1
DROP TABLE t1;
set optimizer_switch=@innodb_icp_tmp;
set storage_engine= @save_storage_engine;
diff --git a/mysql-test/r/join_cache.result b/mysql-test/r/join_cache.result
index 6908f40e854..9918ad2380d 100644
--- a/mysql-test/r/join_cache.result
+++ b/mysql-test/r/join_cache.result
@@ -3520,10 +3520,10 @@ where t1.f1=t2.f1 and t2.f2 between t1.f1 and t2.f2;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where
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_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 20
-Handler_pushed_index_cond_filtered 16
+Handler_icp_attempts 20
+Handler_icp_match 4
set join_cache_level=6;
select t2.f1, t2.f2, t2.f3 from t1,t2
where t1.f1=t2.f1 and t2.f2 between t1.f1 and t1.f2 and t2.f2 + 1 >= t1.f1 + 1;
@@ -3537,10 +3537,10 @@ where t1.f1=t2.f1 and t2.f2 between t1.f1 and t2.f2;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where
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_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 40
-Handler_pushed_index_cond_filtered 32
+Handler_icp_attempts 40
+Handler_icp_match 8
set join_cache_level=7;
select t2.f1, t2.f2, t2.f3 from t1,t2
where t1.f1=t2.f1 and t2.f2 between t1.f1 and t1.f2 and t2.f2 + 1 >= t1.f1 + 1;
@@ -3554,10 +3554,10 @@ where t1.f1=t2.f1 and t2.f2 between t1.f1 and t2.f2;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where
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_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 60
-Handler_pushed_index_cond_filtered 48
+Handler_icp_attempts 60
+Handler_icp_match 12
set join_cache_level=8;
select t2.f1, t2.f2, t2.f3 from t1,t2
where t1.f1=t2.f1 and t2.f2 between t1.f1 and t1.f2 and t2.f2 + 1 >= t1.f1 + 1;
@@ -3571,10 +3571,10 @@ where t1.f1=t2.f1 and t2.f2 between t1.f1 and t2.f2;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where
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_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 80
-Handler_pushed_index_cond_filtered 64
+Handler_icp_attempts 80
+Handler_icp_match 16
drop table t1,t2;
set join_cache_level=default;
#
diff --git a/mysql-test/r/maria_icp.result b/mysql-test/r/maria_icp.result
index b9d3ca6c7c0..97b10fe496c 100644
--- a/mysql-test/r/maria_icp.result
+++ b/mysql-test/r/maria_icp.result
@@ -822,24 +822,24 @@ KEY (c1)
);
INSERT INTO t1 VALUES ('3', '3'),('4','4'),('5','5');
flush status;
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 0
-Handler_pushed_index_cond_filtered 0
+Handler_icp_attempts 0
+Handler_icp_match 0
SELECT * FROM t1 FORCE INDEX(c1) WHERE (c1='3' or c1='4') and c1 % 2 = 0 ;
c1 c2
4 4
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 2
-Handler_pushed_index_cond_filtered 1
+Handler_icp_attempts 2
+Handler_icp_match 1
SELECT * FROM t1 WHERE (c2='3' or c2='4') and c2 % 2 = 0 ;
c1 c2
4 4
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 2
-Handler_pushed_index_cond_filtered 1
+Handler_icp_attempts 2
+Handler_icp_match 1
DROP TABLE t1;
set storage_engine= @save_storage_engine;
set optimizer_switch=@maria_icp_tmp;
diff --git a/mysql-test/r/myisam_icp.result b/mysql-test/r/myisam_icp.result
index d7442608b59..85a2ad921c6 100644
--- a/mysql-test/r/myisam_icp.result
+++ b/mysql-test/r/myisam_icp.result
@@ -820,24 +820,24 @@ KEY (c1)
);
INSERT INTO t1 VALUES ('3', '3'),('4','4'),('5','5');
flush status;
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 0
-Handler_pushed_index_cond_filtered 0
+Handler_icp_attempts 0
+Handler_icp_match 0
SELECT * FROM t1 FORCE INDEX(c1) WHERE (c1='3' or c1='4') and c1 % 2 = 0 ;
c1 c2
4 4
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 2
-Handler_pushed_index_cond_filtered 1
+Handler_icp_attempts 2
+Handler_icp_match 1
SELECT * FROM t1 WHERE (c2='3' or c2='4') and c2 % 2 = 0 ;
c1 c2
4 4
-show status like "Handler_pushed%";
+show status like "Handler_icp%";
Variable_name Value
-Handler_pushed_index_cond_checks 2
-Handler_pushed_index_cond_filtered 1
+Handler_icp_attempts 2
+Handler_icp_match 1
DROP TABLE t1;
drop table if exists t0, t1, t1i, t1m;
#
diff --git a/mysql-test/r/status.result b/mysql-test/r/status.result
index e75cabe0e58..b5bae659eed 100644
--- a/mysql-test/r/status.result
+++ b/mysql-test/r/status.result
@@ -275,9 +275,9 @@ Variable_name Value
Handler_commit 0
Handler_delete 0
Handler_discover 0
+Handler_icp_attempts 0
+Handler_icp_match 0
Handler_prepare 0
-Handler_pushed_index_cond_checks 0
-Handler_pushed_index_cond_filtered 0
Handler_read_first 0
Handler_read_key 4
Handler_read_next 0
@@ -312,9 +312,9 @@ Variable_name Value
Handler_commit 0
Handler_delete 0
Handler_discover 0
+Handler_icp_attempts 0
+Handler_icp_match 0
Handler_prepare 0
-Handler_pushed_index_cond_checks 0
-Handler_pushed_index_cond_filtered 0
Handler_read_first 0
Handler_read_key 2
Handler_read_next 2
diff --git a/mysql-test/r/status_user.result b/mysql-test/r/status_user.result
index 175839b2098..be0cfef79dc 100644
--- a/mysql-test/r/status_user.result
+++ b/mysql-test/r/status_user.result
@@ -100,9 +100,9 @@ Variable_name Value
Handler_commit 19
Handler_delete 1
Handler_discover 0
+Handler_icp_attempts 0
+Handler_icp_match 0
Handler_prepare 18
-Handler_pushed_index_cond_checks 0
-Handler_pushed_index_cond_filtered 0
Handler_read_first 0
Handler_read_key 3
Handler_read_next 0