[nhibernate-issues] [NHJIRA] Updated: (NH-2676) paged join fetch with OpenStatelessSession always results the same rows regardless of SetFirstRow parameter

[Fabio M. (JIRA) <nh...@gm...>]

     [ http://216.121.112.228/browse/NH-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabio Maulo updated NH-2676:
----------------------------

    Priority: Trivial  (was: Major)

> paged join fetch with OpenStatelessSession always results the same rows regardless of SetFirstRow parameter
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: NH-2676
>                 URL: http://216.121.112.228/browse/NH-2676
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.1.0
>            Reporter: Mariusz Florek
>         Attachments: Domain-Customer.zip
>
>
> I tested results of HQL query using standard and stateless session:
> from Customer c
> join fetch c.Orders as o
> left join fetch o.OrderLines as ol
> join fetch ol.Product p
> order by c.CompanyName
> I tried to limit result count using SetFirstResult(...) and SetMaxResults(...) on IQuery object.
> For test I used MsSql2008DialectLinqReadonlyCreateScript.sql from NHibernate 3.1.0-GA zip with binaries.
> With standard session I got proper results - with stateless session I always got first N (set with SetMaxResults) objects regardless of value set with SetFirstResult.
> Additionally query ran with stateless session consumed twice execution time (although I expected it to be faster).
> Problem exists also with simpler join example:
> from Customer c
> join fetch c.Orders
> order by c.CompanyName
> BTW - how NHibernate process such queries (how resolves page to read - I can see only not limited SQL generated)?
> Cheers,
> Mariusz

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira