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.
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.