Actions
Bug #22501
closed
Multiple join conditions are not supported
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-04-22
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
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.
(issue imported from #M14182)
Files
Updated by Xavier Perseguers about 14 years ago
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)
Actions