I'm experiencing the same problem as is described in this Hibernate (not NHibernate) bug report. It's marked as fixed in Hibernate, but can anyone confirm whether this is present in NHibernate (3)?
https://hibernate.onjira.com/browse/HHH-892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32229#action_32229 To sumarise, in a query like this...: select a, sum(tCon.TimesP) as tp from A a inner join a.T as t inner join t.Items as tCon inner join tCon.Item as item where item.id = :itemId group by a order by tp DESC ...NH is complaining that tp is an unknown column in the order by. I'm using NH 3.1.0.4000 with MySQL5Dialect. -- 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.
