Re: [dspam-users] MySQL 4.1 Bug

Well, I can tell you one thing they are going to say. You aren't
running the latest version of the binaries compiled by MySQL AB for your
platform. Try that and see what happens. Seriously, I'm not trying to
be a punk here. They don't backport or release patches for older versions.

j

Kyle Lanclos wrote:
> 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
>
>
> !DSPAM:4333430a276531617156080!

--
Jason Bradley Nance                        What would you cry for?
aitrus@tresgeek.net                          Swallow your pride for?
            Tres Geek                       What would you go wild for?
http://tresgeek.net/
                                                           -Poe, "Wild"
--