HQL parser does not resolve alias in ORDER BY clause ----------------------------------------------------- Key: HHH-892 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 Project: Hibernate3 Type: New Feature

Versions: 3.0.5 Environment: Hibernate 3.0.5, MySQL, Tomcat Reporter: Guido Laures Priority: Minor

When using an alias for an ORDER BY clause this is not always correctly resolved. Example: SELECT SUM(A.x) AS mySum FROM MyClass AS A GROUP BY A.y ORDER BY mySum does not work because "mySum" is not resolved in the ORDER BY clause which results in an exception telling that mySum is an unknown column. Workaround (not to say "hack") is using: SELECT SUM(A.x) AS mySum FROM MyClass AS A GROUP BY A.y ORDER BY col_0_0_