Bug in subqueries?

[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 count(*) from words as w1 where w1.val in (select w3.val 
from words as w3 where w3.val like 'e%');
+----------+
| count(*) |
+----------+
|     1626 |
+----------+
1 row in set (0.78 sec)

mysql> select count(*) from words as w1 where w1.val in (select w2.val 
from words as w2 where w2.val like 'm%') and w1.val in (select w3.val 
from words as w3 where w3.val like 'e%');
+----------+
| count(*) |
+----------+
|    53556 |
+----------+
1 row in set (0.08 sec)

mysql> select count(*) from words;
+----------+
| count(*) |
+----------+
|    53556 |
+----------+
1 row in set (0.00 sec)
Regards,
Andreas Pardeike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]