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

[Xavier Perseguers]

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'

Solution:
Add support for BETWEEN operator

Additional information:
As always, SQL parser from t3lib had to be updated and I added a unit test in DBAL

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13412_core.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100203/3e01862a/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13412_dbal.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100203/3e01862a/attachment.asc>