[TYPO3-core] RFC: Bugfix #7545: Explain select not working with multiple tables

[Benjamin Mack]

Hey Ingo,

just tried the patch. I can reproduce an error when using tt_news in 
list mode. When activated "explain SQL" I get this:

"SHOW INDEX FROM tt_news LEFT OUTER JOIN tt_news_cat_mm ON tt_news.uid = 
tt_news_cat_mm.uid_local"

You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near 'LEFT 
OUTER JOIN tt_news_cat_mm ON tt_news.uid = tt_news_cat_mm.uid_local' at 
line 1

Anyway, I applied your patch and still get the error.


ingo schmitt wrote:
> Hi Benjamin,
> 
>> looks very good. +1 after reading. I'd really like to see this patch in 
>> action though.
>>
>> Can you give us small instructions on how to reproduce this? Thanks a ton!
> 
> Activate: SQL-Debug in Install-Tool
> Activate: Debug and set you IP dev mask to your IP in Install-Tool
> (
> $TYPO3_CONF_VARS['FE']['debug'] = 1;
> $TYPO3_CONF_VARS['SYS']['sqlDebug'] = '1';
> )
> (BTW: Where can I set the later option in installtool 2?)
> 
> Activate: Admin-Panel in TS
> Activate: "Explain SELECT queries" in Admin Panel
> 
> Render in frontent a page with tt_news records:
> 
> "You have an error in your SQL syntax; check the manual that corresponds 
> to your MySQL server version for the right syntax to use near 'INNER 
> JOIN tt_news_cat_mm ON (tt_news_cat.uid = tt_news_cat_mm.uid_foreign)
> ' at line 2
> 
> SHOW INDEX FROM tt_news_cat
> INNER JOIN tt_news_cat_mm ON (tt_news_cat.uid = tt_news_cat_mm.uid_foreign)
> INNER JOIN tt_news ON (tt_news.uid = tt_news_cat_mm.uid_local)"
> 
> 
> ingo
> 
> 
> 
> Mit freundlichen Gruessen

-- 
greetings,
benni.
-SDG-

www.xnos.de // www.xnos.org