Bug #12720 SELECT from VIEW doesn't return rows
Submitted: 22 Aug 2005 10:59 Modified: 8 Sep 2005 20:34
Reporter: Victoria Reznichenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.0.12 OS:Linux (linux)
Assigned to: Sergey Petrunya

[22 Aug 2005 10:59] Victoria Reznichenko
Description:
The following SELECT doesn't return any rows but it should

mysql> select * from bbk_niederlassung_zeit_vi where oid = 21;
Empty set (0.01 sec)

How to repeat:
1. restore tables
2. CREATE VIEW
3. execute SELECT query.
[29 Aug 2005 23:13] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/29003
[30 Aug 2005 13:08] Sergey Petrunya
Fix pushed into 5.0.12 tree.
Bug description for the changelog: 
Queries with subqueries, where the inner subquery uses range or index_merge access method could return wrong results.
[1 Sep 2005 0:48] Paul Dubois
Noted in 5.0.12 changelog.

Sergey, thanks for the bug description!
[6 Sep 2005 21:49] Sergey Petrunya
There was an error: the bug was fixed not in 5.0.12, but in 5.0.13. Please update the documentation.
[8 Sep 2005 20:34] Paul Dubois
I've moved the changelog entry.