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

[Xavier Perseguers]

Hi,

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
> 


-- 
Xavier Perseguers
MVC ExtJS Leader

http://forge.typo3.org/projects/show/extension-mvc_extjs
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 8915_v3.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091102/f6b0ca43/attachment.txt>