#22501Multiple join conditions are not supported
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)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.