List:GUI Tools« Previous MessageNext Message »
From:Jorge del Conde Date:February 5 2004 5:19pm
Subject:Re: MySqlCC LMIT & Subselects
View as plain text  
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.
>
>
>


Thread
MySqlCC LMIT & Subselectsgary.doades5 Feb
  • Re: MySqlCC LMIT & SubselectsJorge del Conde5 Feb