[TYPO3-core] RFC #5120 / #8915: SQL parse error in "Who is online" BE list

[Ernesto Baschny [cron IT]]

Hi,

+1 on reading and testing.

Commited to trunk, rev.6315 (4.3 beta3)

Cheers,
Ernesto

Xavier Perseguers schrieb:

> Just figured out by trying to apply this patch to another Oracle
> instance that it could not apply from typo3_src directory.
> 
> Here is a fix with v3.

> Xavier Perseguers wrote:
>> Hi,
>>
>> This is an SVN patch request.
>>
>> Type: Bugfix in DBAL with a minor update in Core
>>
>> Bugtracker references:
>> http://bugs.typo3.org/view.php?id=5120
>> http://bugs.typo3.org/view.php?id=8915
>>
>> Requires:
>> RFC #10411
>>
>> Branches: trunk
>>
>> Problem:
>> When trying to show the "Who is online" list (from User Admin /
>> (function menu)
>>
>> Solution:
>> Use an INNER JOIN instead of an implicit CROSS JOIN to link tables
>> be_sessions and be_users.
>>
>> Additionally, take into account limitation of the Core parser and
>> reverse the comparison operator and remove extra useless parentheses.
>>
>> This implies that Core's SQL parser is able to parse more than 1 join
>> and as such that patch from RFC #10411 gets committed.
>>
>> Cheers
>>
> 
>