Hi, I also faced this kind of error in sub query, any solution for this?:
-Aman. On Mon, 19 Jan 2004, Director General: NEFACOMP wrote: > Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 > When the SUB-SELECT contains more than one field, it does not work (this works very > well with 4.1.0 !!!!) > > For example: > SELECT field1 FROM Table1 WHERE (field2,field3) IN (SELECT field2,field3 FROM Table2) > > > The above query works as expected with mysqld-nt.exe 4.1.0 (on WinXP) but it does > not work with mysqld-nt.exe 4.1.1 (on WinXP). > This problem causes unexpected results as the recordset comes empty (on 4.1.1) while > it comes with rows with 4.1.0 and no error is returned!!! > > Maybe it is a known bug!!!!! > > > Thanks, > __________________________________ > NZEYIMANA Emery Fabrice > NEFA Computing Services, Inc. > P.O. Box 5078 Kigali > Office Phone: +250-51 11 06 > Office Fax: +250-50 15 19 > Mobile: +250-08517768 > Email: [EMAIL PROTECTED] > http://www.nefacomp.net/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
