[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-892) HQL parser does not resolve alias in ORDER BY clause

HQL parser does not resolve alias in ORDER BY clause ----------------------------------------------------- Key: HHH-892 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-892 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.5.4, 3.6.0.Beta1 Environment: Hibernate 3.0.5, MySQL, Tomcat Reporter: Guido Laures Assignee: Gail Badner Fix For: 3.6.0.CR2 Attachments: HHH-892.patch, HibernateHavingAliasTest.java 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_