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

[ingo schmitt]

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
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung