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.

Reply via email to