diff options
| author | unknown <sanja@montyprogram.com> | 2012-02-22 10:38:28 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-02-22 10:38:28 +0200 |
| commit | c299e027eeddc35e0197ebc70805e0a303a4b135 (patch) | |
| tree | fbe47b9e9d1fea8c0183950d63894d1774ad8a6a /mysql-test/r/myisam_icp.result | |
| parent | c9fc9f73170a8eb16ea968a2ea51b298eb5cdcfc (diff) | |
| download | mariadb-git-c299e027eeddc35e0197ebc70805e0a303a4b135.tar.gz | |
Changed names of statistic variables and counting matches instaed of rejected rows.
Diffstat (limited to 'mysql-test/r/myisam_icp.result')
| -rw-r--r-- | mysql-test/r/myisam_icp.result | 18 |
1 files changed, 9 insertions, 9 deletions
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; # |