Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.3.11
-
None
Description
The following EXPLAIN command from the test case for LP bug #934348
EXPLAIN
|
SELECT a FROM t1 t WHERE a IN (SELECT b FROM t1, t2 WHERE b = a)
|
GROUP BY a HAVING a != 'z';
|
returns
id select_type table type possible_keys key key_len ref rows Extra
|
1 PRIMARY t index idx_a idx_a 4 NULL 1 Using index
|
...
|
It should return
id select_type table type possible_keys key key_len ref rows Extra
|
1 PRIMARY t index idx_a idx_a 4 NULL 3 Using index
|
as the number of rows in the table t1 is equal to 3.