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

[Ries van Twisk]

On Feb 3, 2010, at 9:47 AM, Xavier Perseguers wrote:

> Hi,
>
> FYI, the following patches have been committed to Core trunk (rev.  
> 6841) and DBAL trunk (rev. 29640).
>
> Type: Bugfix
>
> Bugtracker references:
> http://bugs.typo3.org/view.php?id=13412
>
> Problem:
> When using EXT:crawler, the crawler jobs fail with a parseWhere  
> exception. Problem is that generated queries use a BETWEEN operator  
> to retrieve queued jobs:
>
> ((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)