[nhibernate-issues] [NHJIRA] Commented: (NH-2634) NHibernate generates wrong select-query

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

    [ http://216.121.112.228/browse/NH-2634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20858#action_20858 ] 

Kirill Medvedev commented on NH-2634:
-------------------------------------

I've checked another ways to retrieve data. Criteria API and HQL behave the same way, as QueryOver, and cause an exception.

IList<Item> items = session.QueryOver<Item>().Skip(1).Take(20).List();
                
IList<Item> items = session.CreateCriteria<Item>().SetFirstResult(1).SetMaxResults(20).List<Item>();
                
IList<Item> items = session.CreateQuery("from Item").SetFirstResult(1).SetMaxResults(20).List<Item>();

> NHibernate generates wrong select-query
> ---------------------------------------
>
>                 Key: NH-2634
>                 URL: http://216.121.112.228/browse/NH-2634
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Core, QueryOver
>    Affects Versions: 3.1.0
>            Reporter: Kirill Medvedev
>            Priority: Critical
>         Attachments: NH_Bug.zip
>
>
> While transferring legacy project to NHibernate I found a bug... Nhibernate generates wrong SELECT query => GenericADOException occurs. See attachment. Thank you.

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