MySQL Bugs: #3455: Control Center failure to run sub-queries

Bug #3455	Control Center failure to run sub-queries
Submitted:	13 Apr 2004 6:24	Modified:	13 Apr 2004 17:56
Reporter:	Andrew Prseley	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:	0.9.4 beta	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Running MySQL version 4.1.1 for windows and Control Center 0.9.4 beta.  Sub-queries don't appear to work in control center.  I ran the following query in control center

SELECT * FROM RollUp where ID IN (SELECT ParentID FROM RollUp WHERE CostCenter='02207113')

I then received the following error.

ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

I then took the same query and ran it via the mysql command line and it worked just fine.

How to repeat:
Run a sub-query from Control Center

Thank you for the bug report, it is however duplicate of:

http://bugs.mysql.com/bug.php?id=2600