[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-892?page=co... ] siavash mirarab commented on HHH-892: ------------------------------------- Gavin, can you describe why this is not a bug (or point us to anywhere that this might be explained)? One would expect that if hibernate renames an alias in some places, it would rename it everywhere. That just sounds too natural. Are we missing something? Also, for those of you who need to live with the workaround, here is an idea: define an alias for the columns for which you need to order by but call the alias what hibernate would call it. This way, when this issue/new functionality is fixed you would not need to change your code. Here is an example: SELECT SUM(A.x) AS col_0_0_ FROM MyClass AS A GROUP BY A.y ORDER BY col_0_0_ Still, not sure if this workaround is safe when used in different environments and dialects. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira