Bug #22144 EXPLAIN returns wrong information
Submitted: 9 Sep 2006 7:07 Modified: 2 Oct 2007 8:27
Reporter: Georg Richter
Status: Verified
Category:Server: Optimizer Severity:S3 (Non-critical)
Version:5.2 OS:Any
Assigned to: Gleb Shchepa Target Version:6.0
Tags: cwp
Triage: Triaged: D3 (Medium)

[9 Sep 2006 7:07] Georg Richter
Description:
 EXPLAIN returns invalid/wrong information for simple SELECT:

How to repeat:
create table t2 (a int, b int, c int, d int, primary key(a)) engine=Jstar;
insert into t2 values
(1,1,1,1),(2,2,2,2),(3,3,3,3),(4,4,4,4),(5,5,5,5),(6,6,6,6),(7,7,7,7),(8,8,8,8);
explain select distinct(a) from t2;

Output:
+----+-------------+-------+------+---------------+------+---------+------+------+--------
---------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+--------
---------+
| 1 | SIMPLE | t2 | ALL | NULL | NULL | NULL | NULL | 1000 | Using temporary |
+----+-------------+-------+------+---------------+------+---------+------+------+--------
---------+
[18 Sep 2007 7:25] Hakan Kuecuekyilmaz
Test case is falcon_bug_22144.test.
[19 Oct 2007 18:27] Kevin Lewis
Calvin,  The EXPLAIN feature is not under the control of Falcon.