Re: Bug in subqueries?

2004-02-17 Thread Victoria Reznichenko
Andreas Pardeike [EMAIL PROTECTED] wrote: Hi List, should I report the following as a bug? mysql select count(*) from words as w1 where w1.val in (select w2.val from words as w2 where w2.val like 'm%'); +--+ | count(*) | +--+ | 3552

Bug in subqueries?

2004-02-16 Thread Andreas Pardeike
Hi List, should I report the following as a bug? mysql select count(*) from words as w1 where w1.val in (select w2.val from words as w2 where w2.val like 'm%'); +--+ | count(*) | +--+ | 3552 | +--+ 1 row in set (0.78 sec) mysql select