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
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 click
[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 1235:
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,