Why does this query simply *hang* MySQL 4.1 - Jay Dolan - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsWhy does this query simply *hang* MyS...

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.