HQL ORDER BY descending component is not generated properly; DESC is only applied to the last component column --------------------------------------------------------------------------------------------------------------- Key: HHH-5574 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5574 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.6.0.CR1, 3.5.6 Reporter: Gail Badner Assignee: Gail Badner Fix For: 3.6.x HQL ORDER BY descending component is not generated properly; DESC is only applied to the last component column. For example: HQL: select z.name, z.address from org.hibernate.test.hql.Zoo z order by z.address DESC, z.name DESC SQL: select zoo0_.name as col_0_0_, zoo0_.street as col_1_0_, zoo0_.city as col_1_1_, zoo0_.postalCode as col_1_2_, zoo0_.country as col_1_3_, zoo0_.state_prov_id as col_1_4_ from Zoo zoo0_ order by zoo0_.street, zoo0_.city, zoo0_.postalCode, zoo0_.country, zoo0_.state_prov_id DESC, zoo0_.name DESC -- 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