Bug #19734
closedt3lib_db explainOutput does not work with tablealias
0%
Description
Using table aliases in an SQL having t3lib_db::explainOutput ==1 causes mysql errors as t3lib_db::explain function calles explain the executed query and uses returned tablenames to "SHOW INDEX FROM" it. The problem with this is that col 'table' returned by explain can be an alias from a table and then "SHOW INDEX FROM " returns in "table does not exist" error.
code:
$GLOBALS['TYPO3_DB']->exec_SELECTgetRows('a.uid,b.uid','be_users a,be_users b','1');
produces:
caller t3lib_DB::exec_SELECTquery
ERROR Table 'DBNAME.b' doesn't exist
lastBuiltQuery SELECT a.uid,b.uid
FROM be_users a,be_users b
WHERE
1
(issue imported from #M10003)
Files
Updated by Nabil Saleh over 15 years ago
with this patch each table is checked on existance in DB first
Updated by Xavier Perseguers over 14 years ago
Committed:
- trunk (rev. 7073)
- 4-3 (rev. 7074)