HQL: order-by clause column list -------------------------------- Key: HHH-1267 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1267 Project: Hibernate3 Type: Improvement

Components: query-hql Reporter: Steve Ebersole Assignee: Steve Ebersole Priority: Minor

HQL currently always results in using qualified column names in the order-by clause. Some databases (ok DB2) actually do not support this in all cases. And really according to the SQL spec, it is not the specified thing to do. Essentially the SQL spec says that if select-clause column aliases are used, those column aliases (or the column indexes) should be used in the order-by clause. This should be the non-default behavior as it'll be more intensive of the query parser to achieve this.