[TYPO3-core] FYI #14182: Multiple join conditions are not supported

[Xavier Perseguers]

Hi,

FYI following patches have been committed:

- TYPO3 trunk (rev. 7426)
- DBAL trunk (rev. 32481)
- DBAL_1-1 (rev. 32482)

- TYPO3 4-3 (rev. 7427)
- DBAL_1-0 (rev. 32488)



Type: bugfix

Bugtracker reference:
http://bugs.typo3.org/view.php?id=14182

Branches: trunk, 4-3

Problem:

Multiple conditions on a join cannot be parsed:

$rec = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
     '*',
     'T1 LEFT OUTER JOIN T2 ON T2.pid=T1.uid AND T2.size=4',
     'T1.cr_userid=1'
);

Problem is that this query cannot be rewritten due to the T2.size=4 which cannot be moved to the WHERE clause and cannot be left alone as left outer join condition.

Solution:

Fix t3lib_sqlparser to be able to parse multiple conditions in a join clause.

Cheers

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