micah wrote:
> On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote:
>
>> On Wed, 26 Sep 2007, Micah Anderson wrote:
>>
>>> SELECT count(*)
>>> FROM bayes_token
>>> WHERE id = '4'
>>> AND ('1190846660' - atime) > '345600';
>> Who the hell wrote *that* query? Is MySQL smart enough to rearrange that
>> equation to give an indexable comparison?
>
> That comes from /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pl line
> 243. It seems to calculate the expire delta, but in a way that can't use
> an index.
>
> Maybe that query should be changed from:
>
> AND (? - atime) > ?"
>
> to:
>
> AND atime < ? + ?"
>
Can someone please open up a Bugzilla bug for this so it can be tracked?
Thanks
Michael
