We're updating the issue view to help you get more done. 

Wrong estimate of rows in the test case for LP bug #934348

Description

The following EXPLAIN command from the test case for LP bug #934348

1 2 3 EXPLAIN SELECT a FROM t1 t WHERE a IN (SELECT b FROM t1, t2 WHERE b = a) GROUP BY a HAVING a != 'z';


returns

1 2 3 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

1 2 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.

Environment

None

Status

Assignee

Igor Babaev

Reporter

Igor Babaev

Components

Fix versions

Affects versions

5.3.11

Priority

Minor