[TYPO3-core] FYI24 #10003: t3lib_db explainOutput does not work with tablealias

[Dan Osipov]

Thanks!!!

Dan Osipov
http://danosipov.com/blog

On 3/3/10 11:45 AM, Xavier Perseguers wrote:
> Hi,
>
> Committed:
>
> - trunk (rev. 7073)
> - 4-3 (rev. 7074)
>
> Cheers
>
> On 03/01/10 19:06 , Xavier Perseguers wrote:
>> Hi,
>>
>> I'll commit this patch in 24h if nobody objects.
>>
>> Cheers
>> Xavier
>>
>> On 10/29/09 15:22 , Dan Osipov wrote:
>>> This is an SVN patch request.
>>>
>>> Type: Bugfix
>>>
>>> Bugtracker references:
>>> http://bugs.typo3.org/view.php?id=10003
>>>
>>> Branch: 4.2, Trunk
>>>
>>> Problem:
>>>
>>> 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
>>>
>>>
>>> Solution:
>>> Prior to finding the index of the table, check that the table exists.
>>> Thanks to Nabil Saleh for the patch!
>>
>>
>
>


-- 
Dan Osipov
http://danosipov.com/blog