MySQL Bugs: #2498: MYSQLCC: mysql features missing

Bug #2498	MYSQLCC: mysql features missing
Submitted:	24 Jan 2004 9:07	Modified:	26 Jan 2005 21:36
Reporter:	Edouard Lauer	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQLCC	Severity:	S4 (Feature request)
Version:	0.9.4-beta	OS:	Windows (Windows XP)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
Subquerys with IN/ALL/ANY/SOME are not yet included in MysqlCC also I'm using MYSQL 4.1.O. The following query in MYSQLCC:
select * from emp where hiredate< all (select hiredate from emp where deptno=10);
gives me the following message:
[localhost] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
Doing the same query in the mysql command-line shows me the correct result.

Thanks for your help.

How to repeat:
In mysqlcc in the control center try a query with ALL/ANY like this one:
select * from emp where hiredate< all (select hiredate from emp where deptno=10);

Thank you for the bug report.

Thank you for your interest in the MySQL graphical administration tools.
We recommend that you use our MySQL Administrator and MySQL Query
Browser.  The MySQLGUI and MySQL Command Center legacy products are
deprecated, and we are no longer maintaining those projects.

For more information on MySQL Administrator, see:
http://www.mysql.com/products/administrator/