Distinct With Order By producing ORA-01791

Description

This is my HQL query

This generates the following SQL

And this is throwing

ERROR
[org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-9980-1)
ORA-01791: not a SELECTed expression

But the same HQL query generating the following SQL when we used hibernate-3.3.1 GA and its working fine.

Environment

Jboss AS 4.3.2 GA, HIbernate 3.5.5, Oracle 10g

Activity

Show:
Roland Schneider
November 26, 2013, 9:55 AM

Having the same problem. However, I think this is a duplicate of HHH-5926.

Brett Meyer
March 11, 2014, 5:22 PM

Duplicating in favor of

Duplicate

Assignee

Unassigned

Reporter

nick

Fix versions

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major
Configure