diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2012-02-21 20:51:56 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2012-02-21 20:51:56 +0100 |
| commit | edab37cd680ebcca999d989c34251f6be1115c54 (patch) | |
| tree | 9a960e6324916997d8efa87ce8d48d099d78cab8 /mysql-test/include | |
| parent | 5bf311e1e853457c31dbadd3d130b2569a867d80 (diff) | |
| parent | 446554a15bd84f39ec4a8163e9f4456fa9be8fb2 (diff) | |
| download | mariadb-git-edab37cd680ebcca999d989c34251f6be1115c54.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/include')
| -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; + |