Affects Version/s: 2.4.1
Fix Version/s: None
Security Level: All
Environment:Oracle, All OSes.
At 90% of cases when we use ROWNUM in WHERE clause it will work correctly, but sometimes not. I noticed that that is why Doctrine sometimes works incorrect.
"That is why a query in the following form is almost certainly an error:
where ROWNUM <= 5
order by sal desc;
I prepared modified OraclePlatform.php with solution (attachment) - rownum is being compared after all operations.