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,
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.
2 messages in com.mysql.lists.gui-toolsRe: MySqlCC LMIT & Subselects
