Join with a RANGE partitioned table never finishes when the join keys skip a partition, and KILL does not stop it

--source include/have_partition.inc

--source include/have_sequence.inc

CREATE TABLE t1 (x INT, y INT);

INSERT INTO t1 VALUES (5,25);

CREATE TABLE t2 (a INT, b INT, KEY(a)) PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (10), PARTITION p1 VALUES LESS THAN (20), PARTITION p2 VALUES LESS THAN MAXVALUE);

INSERT INTO t2 SELECT seq, seq FROM seq_1_to_3000;

ANALYZE TABLE t1, t2 PERSISTENT FOR ALL;

--connect (con1,localhost,root,,test)

--send SELECT t2.a FROM t1, t2 WHERE t2.a = t1.x OR t2.a = t1.y

--connection default

--sleep 5

--let $c= query_get_value(SELECT COUNT(*) AS c FROM information_schema.PROCESSLIST WHERE INFO LIKE 'SELECT t2.a FROM t1%', c, 1)

if ($c)

{

  --die The join never finishes: the range scan on t2 loops on partition p1, which has no range to read

}

--connection con1

--reap

--disconnect con1

--connection default

DROP TABLE t1, t2;

mysqltest: At line 16: The join never finishes: the range scan on t2 loops on partition p1, which has no range to read