We're updating the issue view to help you get more done. 

Fetch and Paging creates wrong SQL

Description

Hi,
if you creates a query like this:
this.session.Query<Product>().Skip(50).Take(25).Fetch(x=>x.Category);

The following steps are happens:
Select Top 25
JOIN all remaining rows
then skip 50

but it should be like this:
SELECT TOP 25 SKIP 50 AND Join to the 25 rows.

Environment

None

Status

Assignee

Alexander Zaytsev

Reporter

Kai Cissarek

Labels

Components

Affects versions

4.0.1

Priority

Minor