diff options
| author | unknown <sanja@montyprogram.com> | 2012-02-16 08:49:10 +0200 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-02-16 08:49:10 +0200 |
| commit | 607aab9c1d68a3b80bdb52a6c73fd6be1aa52764 (patch) | |
| tree | 3e608459856b6def8c6067cf6b75af813d931585 /mysql-test/include/icp_tests.inc | |
| parent | 764eeeee74f999fe2107fc362236563be0025093 (diff) | |
| download | mariadb-git-607aab9c1d68a3b80bdb52a6c73fd6be1aa52764.tar.gz | |
Counters for Index Condition Pushdown added (MDEV-130).
Diffstat (limited to 'mysql-test/include/icp_tests.inc')
| -rw-r--r-- | mysql-test/include/icp_tests.inc | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/include/icp_tests.inc b/mysql-test/include/icp_tests.inc index e77cb220375..f412843ded0 100644 --- a/mysql-test/include/icp_tests.inc +++ b/mysql-test/include/icp_tests.inc @@ -852,3 +852,25 @@ SET optimizer_switch=@save_optimizer_switch; DROP TABLE t1,t2; +--echo # check "Handler_pushed" status varuiables +CREATE TABLE t1 ( + c1 CHAR(1), + c2 CHAR(1), + KEY (c1) +); + +INSERT INTO t1 VALUES ('3', '3'),('4','4'),('5','5'); + +flush status; +show status like "Handler_pushed%"; + +SELECT * FROM t1 FORCE INDEX(c1) WHERE (c1='3' or c1='4') and c1 % 2 = 0 ; + +show status like "Handler_pushed%"; + +SELECT * FROM t1 WHERE (c2='3' or c2='4') and c2 % 2 = 0 ; + +show status like "Handler_pushed%"; + +DROP TABLE t1; + |