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

EntityGraph with order by using Oracle10gDialect

Description

Using EntityGraphs with Oracle generates incorrect SQL when "order by" clause is added. The same query works correctly in other databases, like HSQL.

I have prepared simple test case:
https://github.com/yuppyavd/hibernate-test-entitygraph/

There are four tests:

  • hsql entitygraph without order by: PASSED

  • oracle entitygraph without order by: PASSED

  • hsql entitygraph with order by: PASSED

  • oracle entitygraph with order by: FAILED

Environment

Hibernate 4.3.6
Oracle 10g/11g

Status

Assignee

Gail Badner

Reporter

Piotr Ostrowski

Fix versions

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

4.3.6

Priority

Major