Bug #4202 | Error 'Unknown table' in second level correlated subquery | ||
---|---|---|---|
Submitted: | 18 Jun 2004 13:29 | Modified: | 2 Sep 2004 11:28 |
Reporter: | Peter Ritzinger | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | 4.1.2a | OS: | Any (all) |
Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[18 Jun 2004 13:29]
Peter Ritzinger
[19 Jun 2004 12:22]
Oleksandr Byelkin
Thank you for bug report, but this bug was already reported as Bug #4090 (http://bugs.mysql.com/bug.php?id=4090)
[2 Sep 2004 10:38]
Peter Ritzinger
In the duplicate bug (#4090) comments was written, that this bug will be fixed in the next server release. However, this bug is still a bug in version 4.1.4-gamma-win32.
[2 Sep 2004 11:28]
Oleksandr Byelkin
oops, sorry. It is not duplicate bug, it is implementation limitation. MySQL can't have correlated subquery in the FROM clause.