Kim,
Got it in one! Thank you so much.
I was using MysqlCC and, although I was aware of the general issue
around limits, I had no idea that it would affect sub-queries.
I tried the query from the command line and it worked. For anyone
else who runs into this, setting
[EMAIL PROTECTED] wrote:
>
> I've upgraded a MySQL 4.0.14 server to 4.1.1-alpha version because I
> wanted to experiment with the support for subqueries. Not being an expert
> on SQL at this point, I tried a couple of simple subqueries and got the
> following error message:
>
>ERROR 1
Had the same problem
Are u calling the query from the MysqlCC ???
, it is adding some info to server about limited the query .
Try from a sql prompt on server
or set the
"automatically limited Select Queries to " -> unlimited
"maximum join size" -> unlimited
on the tab : mysql options (right
I've upgraded a MySQL 4.0.14 server to 4.1.1-alpha version because I
wanted to experiment with the support for subqueries. Not being an expert
on SQL at this point, I tried a couple of simple subqueries and got the
following error message:
ERROR 1235: This version of MySQL doesn't yet
