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

[Ingo Schmitt]

Hi,

this is a SVN patch request.

Type: Bugfix

Branches: 4.2.

Bugtracker:
http://bugs.typo3.org/view.php?id=7545

Problem:
When using the explain select option in the admin panel and having 
extension with more than one table to select from, the "show index" 
statment. An Error in the Frontent is issued:
E.G.
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 
'tx_commerce_products_categories_mm,tx_commerce_articles, 
tx_commerce_article_pri' at line 1
SHOW INDEX FROM tx_commerce_products 
,tx_commerce_products_categories_mm,tx_commerce_articles, 
tx_commerce_article_prices


Solution:
Split the fromTable string into parts and walk through the parts. See 
attached patch.

Note:
I first checked if its 'legal' to use more than one table in the 
fromTable variable, the inline documentation states:

Table(s) from which to select. This is what comes right after "FROM 
...". Required value.




Best regards

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
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: patch_explainselect_multitables.patch
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20080215/9e1a8157/attachment.txt