Re: Bayes innodb problems

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?

--
 John Hardin KA7OHZ                    
http://www.impsec.org/~jhardin/
 jhardin@impsec.org    FALaholic #11174     pgpk -a jhardin@impsec.org
 key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  Pelley: Will you pledge not to test a nuclear weapon?
  Ahmadeinejad: CIA! Secret prison in Europe! Abu Ghraib!
                   -- Mahmoud Ahmadeinejad clumsily dodges a question
                                    (60 minutes interview, 9/20/2007)
-----------------------------------------------------------------------
 242 days until the Mars Phoenix lander arrives at Mars