Pointless Take call wrecks Oracle dialect paging.

Description

A Linq query like query.Skip(5).Take(5).First() fails retrieving corresponding item when using Oracle Dialect.

This trouble is demonstrated since long by the failure NHibernate.Test.Linq.MiscellaneousTextFixture.TriplePageSelection with Oracle. This test, supposed to test paging, is indeed altering its paging by retrieving only the first element on the paged query without having executed the page retrieval previously.

Environment

None

Activity

Frédéric Delaporte 
August 2, 2017 at 11:01 AM
(edited)

A (for now ignored) test case has been committed.

Details

Assignee

Reporter

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created July 31, 2017 at 10:49 AM
Updated December 17, 2018 at 11:42 AM
Who's Looking?