Hello Guenther, The following commit in general describes my thoughts: https://github.com/lukasz-antoniak/hibernate-core/commit/fa8427937f5751170714ec97ac059bee9efd8cff It probably needs some more tuning. Feel free to modify and test. I'm not sure if adding "TOP(100)PERCENT" expression would not harm performance too much.
Totally agree that we should simplify things. This is why I wanted to change the query structure, so that aliases do not get stripped from the original query, DISTINCT is not simulated with GROUP BY etc. Regards, Lukasz _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
