HQL ORDER BY descending component is not generated properly; DESC is only applied to the last component column

Description

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

Environment

None

Activity

Show:
Gail Badner
September 16, 2010, 10:32 PM

I've checked a test into trunk that reproduces this issue:
org.hibernate.test.hql.ASTParserLoadingOrderByTest.testOrderByComponentDescNoSelectAliasRefFailureExpected().

Stephan Bublava
February 8, 2011, 11:14 AM

Does this ticket cover user types that map to multiple columns or should I open a second one instead?

Gail Badner
February 8, 2011, 7:34 PM

Yes, the fix for this issue will also cover user types.

Steve Ebersole
October 27, 2015, 7:15 PM

This bug report does not indicate that the reported issue affects version 5.x. Versions prior to 5.x are no longer maintained. It would be a great help to the Hibernate team and community for someone to verify that the reported issue still affects version 5.x. If so, please add the 5.x version that you verified with to the list of affected-versions and attach the (preferably SSCCE) test case you used to do the verification to the report; from there the issues will be looked at during our triage meetings.

For details, see http://in.relation.to/2015/10/27/great-jira-cleanup-2015/

Steve Ebersole
October 28, 2015, 3:24 AM

As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.

Assignee

Gail Badner

Reporter

Gail Badner

Fix versions

None

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure