forum.lissyara.su

Код: Выделить всё

0. CHECK FOR 4.1 BUG

Some versions of 4.1 apparently have a bug with the way bigint's are handled.
If you have this bug, you'll need to either upgrade to a better version of
MySQL or use the 4.0 (speed, space) object scripts for DSPAM instead of the 4.1
scripts.

To check for this bug, log into MySQL and issue these statements:

create table dspam_test (token bigint(20));

insert into dspam_test values('3232933621568372736'),('5174632569486238062'),('5860192774298853742'),('8787532532089676142'),('8029914733239132526');

select token from dspam_test where token in('3232933621568372736','8787532532089676142','8029914733239132526','5174632569486238062','5860192774298853742');

Broken versions of MySQL will return only one row, whereas a working
version will return all five rows.