When using fetch="join" different data is returned than using fetch="select". Is this a wanted feature? I thought it would simply change the way NHibernate loads the same data.

fetch="select": Executes one query per subobject (if batch-size="1")

fetch="join": Generates an outer join in sql which leads to a wrong parent-object count.

I have found this changeset entry:

:arrow: http://fisheye.cenqua.com/changelog/nhi ... 1003125708

which leads me to the conclusion that this feature concerns a bug because it is experimental and was not tested well.

Thank you for any advise, I am working on this problem for days now... :(
As a work around I could use HQL, right?

For a more detailed problem description have a look at my earlier post:
http://nhibernate.sourceforge.net/forum ... php?t=1017