[TYPO3-core] [OT] FYI #13412: BETWEEN operator is not supported

[Xavier Perseguers]

Hi Ries,

>> ((scheduled BETWEEN 1265068628 AND 1265068828 ) OR scheduled <=
>> 1265068728) AND NOT exec_time AND page_id=1 AND parameters_hash =
>> '854e9a2a77'
>
> OT:
>
> This looks like a horrible query...
>
>> ((scheduled BETWEEN 1265068628 AND 1265068828 ) OR scheduled <=
>> 1265068728)
>
> Why not do
>
> (scheduled BETWEEN 0 AND 1265068828 )
>
> Or simply...
>
> (scheduled <= 1265068728)

Ask the crawler team... ;-)

But if you read it carefully (I wrote it as it appears in my logs), you'll notice that the OR part does not contain the same timestamp as the second operator of the BETWEEN. There's some 
grace/sleeping period when running the crawler and I guess this is somehow related...

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en