Bug #8019 | correlated subqueries in from (nested) | ||
---|---|---|---|
Submitted: | 19 Jan 2005 20:35 | Modified: | 10 Oct 2019 21:17 |
Reporter: | Martin Friebe (Gold Quality Contributor) (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
Version: | 5.0.x, 4.1.9 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | qc |
[19 Jan 2005 20:35]
Martin Friebe
[9 Oct 2006 16:23]
Shay Pierce
I'm very surprised that this feature still isn't in place. Just wanted to 'second' its request, it's something I'm very interested in as well.
[12 Oct 2006 12:21]
Valeriy Kravchuk
Bug #23172 was marked as a duplicate of this one. This is a reasonable feature request.
[12 Dec 2008 13:03]
Valeriy Kravchuk
Bug #41427 was marked as a duplicate of this one.
[12 Dec 2008 13:35]
Arjen lastname
I actually don't understand why the first query of Martin works... Its - afaik - not valid SQL, since columns in the select list can't reference eachother. His first example can be simplified to: select 1 as aa, (select aa); And that is semantically equivalent to: select 1 as aa, aa; But the second query is (imho) correctly seen as invalid. Both duplicated bugreports contain valid sql-examples.
[10 Oct 2019 21:17]
Roy Lyseng
Posted by developer: Implemented in 8.0. But please note this is a non-standard feature.