Hi!
This is not a MySQLCC bug. It's a MySQL bug and should be fixed in the
4.1.2
In the mean time, change the auto LIMIT queries option in MySQLCC to
unlimited.
Regards,
Jorge del Conde
----- Original Message -----
From: <gary.doades@stripped>
To: <mysqlcc@stripped>
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
the
> server. The server version is 4.1.1 and MySqlCC is 0.9.4 all on WinXP. I
am issuing
> a SQL statement of the form:
>
> select * from main_order where client_id in (select client_id from client
where
> area=1)
>
> 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
to
> 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
the
> SQL statement that the server does not like. The SQL works fine with mysql
> command line tool.
> Any suggestions welcome.
> Thanks
> Gary.
>
>
>
