Issue Bug Closed

#18221SQL Error when Explain Queries with multiple tables

Ingo Schmitt 02/15/08, 19:42 updated 08/06/10, 13:19

Description

When using the feature “explain select queries” with exec select queries with more than one table, an error is show. This is caused when in the from clause “table1, table2” is used, since the from clause is used on “show index from $fromClause”

Error Message:
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

see attached patch
(issue imported from #M7545)

Reviews 0

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