This is not a MySQLCC bug. It's a MySQL bug and should be fixed in the
In the mean time, change the auto LIMIT queries option in MySQLCC to
Jorge del Conde
----- Original Message -----
Sent: Thursday, February 05, 2004 10:05 AM
Subject: MySqlCC LMIT & Subselects
> There appears to be a problem with the way that MySqlCC is passing SQL to
> server. The server version is 4.1.1 and MySqlCC is 0.9.4 all on WinXP. I
> a SQL statement of the form:
> select * from main_order where client_id in (select client_id from client
> I get a message in response:
> ERROR 1235: This version of MySQL doesn't yet support 'LIMIT &
> IN/ALL/ANY/SOME subquery'
> I have seen a previous report where setting the "maximum number of results
> save" as Unlimited sorts it. Unfortunately this does not seem to solve the
> problem for me. It appears that MySqlCC is injecting a LIMIT clause into
> SQL statement that the server does not like. The SQL works fine with mysql
> command line tool.
> Any suggestions welcome.