We're updating the issue view to help you get more done. 

ORDER BY syntax regression

Description

Hibernate 3 throws HibernateQueryException: unexpected AST node with the following query, where 2.1 worked:

from Country order by code in ('US','CA','GB') desc, name

This enables bumping frequently used countries to the top of a drop-down.

Environment

Hibernate 3.1.2
MySQL 4.1
Java 1.5

Status

Assignee

Unassigned

Reporter

SethS

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.1.2

Priority

Major