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

[Ries van Twisk]

On Feb 4, 2010, at 1:04 AM, Xavier Perseguers wrote:

> 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...
>

Crap yeaa... I see it now,

still a horrible query though, databases don't like OR, whish was my  
main catch...

Ries






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100204/d713c8c1/attachment.htm>