Actions
Bug #15819
closed
Incorrect parsing of join conditional expression
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-03-14
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
The following query:
$res = $TYPO3_DB->exec_SELECTquery(
'sys_language.uid',
'sys_language LEFT JOIN static_languages ON sys_language.static_lang_isocode=static_languages.uid',
'static_languages.lg_typo3='.$TYPO3_DB->fullQuoteStr($LANG->lang,'static_languages').
t3lib_pageSelect::enableFields('sys_language').t3lib_pageSelect::enableFields('static_languages')
);
is parsed as:
SELECT sys_language.uid FROM sys_language LEFT JOIN static_languages ON sys_language.static_lang_isocode=sys_language.uid WHERE static_languages.lg_typo3 = 'fr' AND sys_language.hidden = 0
Notice the table names in the join conditional expression.
(issue imported from #M2860)
Updated by Stanislas Rolland over 18 years ago
Attached patch fixes the problem.
Updated by Stanislas Rolland over 18 years ago
Fixed in TYPO3core CVS branch TYPO3_4-0.
Actions