Thanks, that works! On May 5, 3:28 pm, Fabio Maulo <[email protected]> wrote: > select t from Domain.Task t left join t.Holder h order by > h.Name<http://t.holder.name/> Desc, > t.Revision Asc > > On Wed, May 5, 2010 at 10:12 AM, Daniel Kolman <[email protected]>wrote: > > > > > > > Hi, > > > recently we upgraded to NHibernate 2.1.2 GA. Since that time I'm > > having trouble with HQL query that worked perfectly in NHibernate 2.0: > > > select t from Domain.Task t left join t.Holder order by t.Holder.Name > > Desc, t.Revision Asc > > > Every Task object has property Holder of type User (many-to-one > > mapping). Task.Holder can be null. The query should list all Tasks, > > regardless whether they have or have not a Holder, and order them by > > Holder.Name property. > > > In NHibernate 1.2 and 2.0 it generates correct SQL: > > > select ... > > from TestDB.dbo.tblTask task0_ > > left outer join TestDB.dbo.tblUser user1_ on task0_. > > [Holder_Id]=user1_.Id > > order by user1_.[Name] Desc , task0_.[Revision] Asc > > > But in NHibernate 2.1.2, it adds the user table again to the query, > > and adds WHERE clause that removes Tasks that has no Holder: > > > select ... > > from TestDB.dbo.tblTask task0_ > > left outer join TestDB.dbo.tblUser user1_ on task0_. > > [Holder_Id]=user1_.Id, > > TestDB.dbo.tblUser user2_ > > where task0_.[Holder_Id]=user2_.Id > > order by user2_.[Name] Desc, task0_.[Revision] Asc > > > Is there any workaround for this? > > > Thanks for replies. > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<nhusers%[email protected] > > > > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > Fabio Maulo > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/nhusers?hl=en.
-- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
