Re: Bayes innodb problems

• Michael Parker <parkerm@pobox.com> [070926 21:14]:
  > 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?
  

http://issues.apache.org/SpamAssassin/show_bug.cgi?id=5661

Micah Received on Fri Sep 28 10:40:36 2007