3 messages in com.mysql.lists.bugsWhy does this query simply *hang* MyS...
FromSent OnAttachments
Jay Dolan17 Jul 2003 07:49 
Indrek Siitan17 Jul 2003 10:22 
Indrek Siitan18 Jul 2003 00:53 
Subject:Why does this query simply *hang* MySQL 4.1
From:Jay Dolan (jdo@windmillcycles.com)
Date:07/17/2003 07:49:15 AM
List:com.mysql.lists.bugs

This works:

select id from table1 where table2_id in (select id from table2 where select_me='true');

While this causes MySQL to simply hang:

select id from table1 where table2_id in (select id from table2 where table3_id in (select id from table3 where select_me='true'));

In other words, MySQL just sits there when I enter a nested "in" subquery. No syntax complaints, no result set..just, nothin ;P

Is there a different syntax I should be using?

MySQL 4.1.0-0 rpm install on stock Red Hat 7.2.