Re: [dspam-users] MySQL 4.1 Bug

I'm using MySQL 4.1.9 on a Solaris 9 (sparc) machine, and I also get an odd
number of rows returned-- 3. Has any determination been made by the MySQL
people about which versions of MySQL are affected? Which versions of dspam
are affected?

mysql> select * from delete_me;
+---------------------+
| token |
+---------------------+
| 3232933621568372736 |
| 5174632569486238062 |
| 5860192774298853742 |
| 8787532532089676142 |
| 8029914733239132526 |
+---------------------+
5 rows in set (0.02 sec)
 
 mysql> select token from delete_me where token in ('3232933621568372736','5174632569486238062','5860192774298853742','8787532532089676142','8029914733239132526');
 +---------------------+
 | token |
 +---------------------+
 | 3232933621568372736 |
 | 5860192774298853742 |
 | 8029914733239132526 |
 +---------------------+
 3 rows in set (0.00 sec)

...if you do the query without the quotes (these are integers, why not always
do it without the quotes?), all five rows are returned.

--Kyle
Received on Thu Sep 22 19:49:54 2005