Bug #66667 | Subquery in where clause deriving columns from parent query (correlated query) | ||
---|---|---|---|
Submitted: | 3 Sep 2012 14:34 | Modified: | 18 Feb 2013 9:09 |
Reporter: | Andrew Rose | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: General | Severity: | S4 (Feature request) |
Version: | 5.5.24 | OS: | Any |
Assigned to: | Jørgen Løland | CPU Architecture: | Any |
[3 Sep 2012 14:34]
Andrew Rose
[18 Feb 2013 9:09]
Jørgen Løland
Hi Andrew, Thank you for the feature request. I'm afraid we won't fix this because it contradicts the SQL standard. A suggestion to avoid confusion is to use unique aliases for all tables in a query: select * from tbl0 as outer where outer.userid in (select inner.userid from tbl1 as inner);