Issue Bug Closed

#15819Incorrect parsing of join conditional expression

Stanislas Rolland 03/14/06, 07:06 updated 08/12/06, 14:20

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.