Bug #18221: SQL Error when Explain Queries with multiple tables - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #18221

closed

SQL Error when Explain Queries with multiple tables

Added by Ingo Schmitt almost 17 years ago. Updated over 14 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Michael Stucki

Category:

Database API (Doctrine DBAL)

Target version:

Start date:

2008-02-15

Due date:

% Done:

Estimated time:

TYPO3 Version:

4.2

PHP Version:

5.2

Tags:

Complexity:

Is Regression:

Sprint Focus:

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)

Files

Download all files

patch_explainselect_multitables.patch (1011 Bytes) patch_explainselect_multitables.patch		Administrator Admin, 2008-02-15 19:42
class.t3lib_db.7545.patch (2.13 KB) class.t3lib_db.7545.patch		Administrator Admin, 2008-02-20 23:47