[nhibernate-issues] [JIRA] Updated: (NH-473) order-by in <bag> is ignored if FetchMode is Join

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-473?page=all ]

Sergey Koshcheyev updated NH-473:
---------------------------------

    Fix Version: LATER

> order-by in <bag> is ignored if FetchMode is Join
> -------------------------------------------------
>
>          Key: NH-473
>          URL: http://jira.nhibernate.org/browse/NH-473
>      Project: NHibernate
>         Type: Improvement
>   Components: Core
>     Versions: 1.0.1
>     Reporter: Stefan Lieser
>      Fix For: LATER

>
> Given the following mapping:
> 	<class name="Example.Book, Example" table="Books" >
> 		<id name="Id" column="RecID" type="System.Int64" unsaved-value="0">
> 			<generator class="native" />
> 		</id>
> 		<property name="Name" column="Name" type="System.String" />
> 		<bag name="Pages" lazy="true" order-by="PageNo" >
> 			<key column="BookID" />
> 			<one-to-many class="Example.Page, Example" />
> 		</bag>
> 	</class>
> If I retrieve an object of class Book and let the Pages collection lazy load, everything is ok. The Pages collection is loaded on acces and ordered by PageNo:
> 	ICriteria criteria = session.CreateCriteria(typeof(Book));
> 	criteria.Add(Expression.Eq("Name", name));
> 	Book book = criteria.UniqueResult() as Book;
> 	...
> 	int count = book.Pages.Count;	// collection is loaded with "order by PageNo" in the SQL statemenet
> But if I retrieve the Book with FetchMode.Join on the Pages collection, the order-by is ignored:
> 	ICriteria criteria = session.CreateCriteria(typeof(Book));
> 	criteria.Add(Expression.Eq("Name", name));
> 	criteria.SetFetchMode("Details", FetchMode.Join);
> 	Book book = criteria.UniqueResult() as Book;	// collection is loaded without "order by" in the SQL
> Sincerely,
> Stefan Lieser

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