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

[13 Apr 2004 6:24] Andrew Prseley
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
[13 Apr 2004 17:56] MySQL Verification Team
Thank you for the bug report, it is however duplicate of:

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