Performing a descending order by on a composite field generate the incorrect SQL for the query.
For example:
{code}
session.createQuery("from SampleTable order by someCompositeField desc").getResultList();
{code}
This will return the incorrect SQL:
{code}select s.* from SampleTable s order by * someCompositeField.arg1 * , someCompositeField.arg2 desc{code}
Whereas I'd expect the SQL to be:
{code}select s.* from SampleTable s order by * someCompositeField.arg1 desc * , someCompositeField.arg2 desc{code}
I've attached a test case to demonstrate the problem. This looks to be have been raised, and closed before as HHH-7025.
I have a fix for the {{org.hibernate.dialect.Dialect}} class, modifying the {{renderOrderByElement(...)}} method, and will raise a pull request for it soon.
Thanks |
|
