Bug #5489 syntax error in subqueries
Submitted: 9 Sep 2004 11:56 Modified: 9 Sep 2004 13:03
Reporter: Yamigo Support Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.16-max-debug OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[9 Sep 2004 11:56] Yamigo Support 
Description:
SubQueries dont really seem to work. I tried exactly the one you have here:

SELECT s1 FROM t1 WHERE s1 IN    (SELECT s1 FROM t2);

[home] ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT s1 FROM t2)' at line 1

I run on 4.0.16-max-debug for windows

How to repeat:
create two tables  t1 and t2 with varchar columns s1 and s2, type in the mysql Control Center 0.9.4 Beta
SELECT s1 FROM t1 WHERE s1 IN    (SELECT s1 FROM t2);
[9 Sep 2004 13:03] MySQL Verification Team 
Hi,

Thank you for the report, but this is not a bug. MySQL supports subqueries since version 4.1.0.
See MySQL manual for more detailes:
http://dev.mysql.com/doc/mysql/en/index.html
[9 Sep 2004 13:10] Yamigo Support 
Thanks a lot. I spent two days trying to figure out what was wrong. I just found out about it searching thru your mailing lists. Thanks for your extremely prompt answer. 
Please consider it closed.