On 7 Feb 2006, at 17:47, Alastair Houghton wrote:
Hi all,
Another patch; MySQL doesn't currently support correlated
subqueries in FROM clauses. This improves the error message you
get in that situation. (I didn't actually want or need a
correlated subquery, but I also spent quite some considerable time
trying to work out what was going on because MySQL threw a syntax
error rather than explaining that it didn't like correlated
subqueries in the FROM part of a SELECT.)
(Note: I have assumed that it's only possible to reach this code
with a subquery in the FROM clause or the WHERE clause... if it's
also possible to get here with a scalar or row subquery, then this
code isn't quite right.)
Oops. Just realised, this patch is in the wrong place :-) It should
be checking whether anything actually correlated, not stopping things
from working in cases where there was no correlation :-D
Kind regards,
Alastair.
--
http://www.alastairs-place.net
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
