Duplicate
Details
Details
Assignee
Richard Brown
Richard BrownReporter
Brian Berns
Brian BernsComponents
Fix versions
Affects versions
Priority
Who's Looking?
Open Who's Looking?
Created August 23, 2011 at 12:13 AM
Updated July 8, 2015 at 4:44 AM
Resolved August 24, 2011 at 11:52 AM
Using ODP.NET, create an IQuery and invoke .SetFirstResult(3) and .SetMaxResults(5). This should fetch 8 records, then skip the first 3 records, and then take the next 5 records. Instead, it fetches only 5 records, then skips the first 3, and then returns only 2. The resulting query looks like this:
select col1, col2, ...
from (
select col1, col2, ...
order by col1, col2, ...
)
where rownum <=5
The where-clause should compare to 8, not 5.
This worked fine in NHib 3.1.0.
I would create a unit test, but this is an Oracle-specific bug.