Hi all, We are currently running into problems with the Hibernate issue mentioned above, you can find it here: https://hibernate.onjira.com/browse/HHH-879
I realize this issue has a bunch of workarounds, but it just rubs me the wrong way :) Now, this never got fixed in Hibernate afaik, but I was wondering if anyone had taken a stab at fixing it in NH. Just looking at the code I'm naively assuming the problem is related to the CriteriaQueryTranslator using the alias as a key in a Dictionary, but then I guess there's a good reason it does that. One of the workarounds mentioned in the Hibernate ticket is to create views in the database pointing to the same tables etc, but I was wondering if it would also be possible to do this kind of workaround in the CriteriaQueryTranslator, i.e. add some kind of unique suffix to the aliases or use a tuple<aliasName, autoincrementing id> as a key. The reason I'm thinking this should be possible is because afaik HQL does not suffer from this limitation. Does anyone have any suggestions? Roy
