With a hql query that fetches a collection of child objects, duplicate parent objects are returned. This appears to be by design (from the Hibernate FAQ), but every user has to remove the duplicates by hand.

Is it possible to change this behaviour, so that no duplicates are returned?

Created NH-300 for the request.

Ah great, thanks!

Btw, it's not too difficult removing the duplicates from the list and you can easily build a generic routine to do this, but it just 'feels' so stupid :).

I believe this and issue 273 are one in the same. I had previously assumed it was only the ICriteria interface that suffered from this, but after discovering the source of the problem (which I commented on in 273), it makes more sense that any method to query would suffer.

So I already have a working fix in my own build (which I documented in the comments), but since the change in behaviour is so big, (and it seems a fix should be possible before the result return, so my solution seemed less than optimal), I wasn't sure it should be "THE" fix?

Anyways, thanks guys for an awesome tool, and all the time and effort you put into it! The code is in really nice shape too... it took me much less time to figure this issue out than I would have guessed not knowing anything at all about the internal design of NHibernate, and I definitely think that's directly attributeable to the obvious commitment to quality you guys have. Well, that and Resharper! :D