Re: Exists BUG in "IN" ?

2005-09-26 Thread Michael Stassen
Dyego Souza Dantas Leal wrote: Hello Guys, I'm using the 5.0.12 version of MySQL PRO on AMD64 3000+ with 1 GB of ram and using the InnoDB Tables.. Here is the Select: mysql> select f1.fc_package from svcs_filecontrol f1 where f1.fc_id in ( -> *select max(f2.fc_id) from svcs_filecontr

Exists BUG in "IN" ?

2005-09-26 Thread Dyego Souza Dantas Leal
Hello Guys, I'm using the 5.0.12 version of MySQL PRO on AMD64 3000+ with 1 GB of ram and using the InnoDB Tables.. Here is my table: CREATE TABLE `svcs_filecontrol` ( `fc_id` int(10) unsigned NOT NULL auto_increment, `fc_us_id_lockby` int(10) unsigned default NULL, `fc_lbl_id` int(10) un