SHOW EXPLAIN: Plan produced by regular explain says 'Using index condition', but SHOW EXPLAIN does not

SELECT SLEEP(0.03)

FROM ( SELECT * FROM t1 ) AS alias

WHERE alias.a < ALL (

SELECT b FROM t2, t3 WHERE c = b AND d = b );

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	20	Using where

3	DEPENDENT SUBQUERY	t2	ALL	NULL	NULL	NULL	NULL	20	Using where

3	DEPENDENT SUBQUERY	t3	ref	d	d	5	test.t2.b	7	Using index condition; Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	20	Using where

3	SUBQUERY	t2	ALL	NULL	NULL	NULL	NULL	20	Using where

3	SUBQUERY	t3	ref	d	d	5	test.t2.b	7	Using where

revision-id: psergey@askmonty.org-20120607171922-w5d79pe7733jrh2r

date: 2012-06-07 21:19:22 +0400

revno: 3412

CREATE TABLE t1 (a INT NOT NULL) ENGINE=Aria;

INSERT INTO t1 VALUES

(0),(8),(1),(8),(9),(24),(6),(1),(6),(2),

(4),(8),(4),(4),(7),(4),(1),(9),(4),(8);

CREATE TABLE t2 (b INT) ENGINE=Aria;

INSERT INTO t2 VALUES

(7),(0),(9),(3),(4),(2),(5),(3),(1),(3),(6),

(7),(5),(1),(204),(224),(9),(5),(0),(3);

CREATE TABLE t3 (c INT, d INT, KEY(d)) ENGINE=Aria;

INSERT INTO t3 VALUES

(4,4),(8,5),(0,2),(0,5),(0,1),(7,1),(7,2),(5,2),

(3,2),(8,1),(4,4),(9,5),(6,3),(1,1),(5,2),(6,7),

(2,6),(4,1),(1,1),(4,8),(3,7),(3,2),(7,6),(6,2),

(7,1),(9,0),(4,7),(4,5),(2,7),(1,2),(2,1),(94,80),

(2,3),(3,8),(8,5),(4,0),(9,9),(4,9),(5,7),(5,0),

(9,5),(3,6),(8,9),(0,3),(9,9),(3,6),(1,7),(0,3),

(18,16),(8,7),(3,7),(3,6),(9,5),(6,8),(8,7),(3,2),

(9,1),(5,3),(9,6),(2,6),(2,5),(5,0),(8,7),(6,7),

(9,6),(0,0),(3,0),(6,8),(5,0),(8,4),(2,0),(12,13),

(25,248),(1,1),(3,6),(1,6),(3,3),(15,14),(5,0),

(9,7),(1,6),(8,6),(7,8),(6,5),(2,8),(4,7),(7,3),

(3,7),(8,3),(4,8),(6,0),(1,1),(7,3),(1,6),(0,8),

(2,1),(7,1),(2,9),(1,0),(5,6);

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

let $con_id = `SELECT CONNECTION_ID()`;

EXPLAIN 

SELECT SLEEP(0.03)

FROM ( SELECT * FROM t1 ) AS alias

WHERE alias.a < ALL (

SELECT b FROM t2, t3 WHERE c = b AND d = b );

--send

SELECT SLEEP(0.03)

FROM ( SELECT * FROM t1 ) AS alias

WHERE alias.a < ALL (

SELECT b FROM t2, t3 WHERE c = b AND d = b );

--connection default

let $fail = 100;

while ($fail)

{

  --error 0,ER_ERROR_WHEN_EXECUTING_COMMAND

  --eval SHOW EXPLAIN FOR $con_id

  --dec $fail

  if (!$mysql_errno)

  {

    let $fail = 0;

  }

}

let $pass = 1;

while ($pass)

{

  --error 0,ER_ERROR_WHEN_EXECUTING_COMMAND

  --eval SHOW EXPLAIN FOR $con_id

  if ($mysql_errno)

  {

    let $pass = 0;

  }

}

--connection con1

--disable_result_log

--reap