BUG#1000051: Query with simple join and ORDER BY takes thousands times longer when run with ICP

- Disable IndexConditionPushdown for reverse scans.

1 files changed, 18 insertions, 1 deletions

diff --git a/mysql-test/r/myisam_icp.result b/mysql-test/r/myisam_icp.result
index 188347c3324..fdb8018dab6 100644
--- a/mysql-test/r/myisam_icp.result
+++ b/mysql-test/r/myisam_icp.result
@@ -165,7 +165,7 @@ WHERE ts BETWEEN '0000-00-00' AND '2010-00-01 00:00:00'
 ORDER BY ts DESC
 LIMIT 2;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	4	Using index condition
+1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	4	Using where
 
 DROP TABLE t1;
 #
@@ -909,4 +909,21 @@ c	NULL	NULL
 c	NULL	NULL
 SET optimizer_switch=@save_optimizer_switch;
 DROP TABLE t1,t2,t3,t4;
+#
+# BUG#1000051: Query with simple join and ORDER BY takes thousands times longer when run with ICP
+#
+create table t0 (a int);
+insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+create table t1 (a int, col int, filler char(100), key(a, col));
+insert into t1 select A.a + 10*B.a +100*C.a, 1234, 'filler' from t0 A, t0 B, t0 C;
+# Must not use ICP:
+explain select * from t1 where a between 10 and 20 order by a, col desc;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	range	a	a	5	NULL	11	Using index condition; Rowid-ordered scan; Using filesort
+# Must not use ICP:
+explain select * from t0,t1 where t1.a=t0.a and t1.col<123;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t0	ALL	NULL	NULL	NULL	NULL	10	Using where
+1	SIMPLE	t1	ref	a	a	5	test.t0.a	1	Using index condition
+drop table t0, t1;
 set optimizer_switch=@myisam_icp_tmp;