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
|