Hello everybody.
Hibernate version:2.0.1.4000

I am receiving some unexpected results when trying to build join criteria (via CreateCriteria or CreateAlias) over many-to-one relation:
I have Entity1. It has one-to-many relation to Entity2. Entity2 has many-to-one relation to Entity3.

So I'm trying to do something like this:

ICriteria crit = uow.CreateCriteria(typeof(Entity1));
crit.CreateAlias("Entity2Collection", "en2Alias").CreateAlias("en2Alias.en3Property", "en3Alias").Add(Restrictions.Eq("en3Alias.name", "deafsheep")).List();

What I receive is that in WHERE of query there is en3Alias.name = ?, but the actual JOIN of en3Alias does not happen. But JOIN of en2Alias happens.

Using CreateCriteria produces same results.

Any suggestions?

Thanks in advance