NH-4061 - Pointless Take call wrecks Oracle dialect paging.

[nhibernate-bot]

Frédéric Delaporte created an issue — 31st July 2017, 10:49:23:

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.

---

Frédéric Delaporte added a comment — 2nd August 2017, 11:01:13:

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