Ivy 12 Sorting/Ordering not working

[stefanmasek]

Dear @ivy-sgi, we have found the following bug:

Describe the bug
The ordering/sorting doesn't work and is always ascending if using Ivy 12. My investigation found that it's because of the following reason:

In Ivy 12 there is a new version of Hibernate that changed the implementation of the OrderImpl.reverse() method as following:

public Order reverse() {
    return new OrderImpl( expression, !ascending );
}

Now this method returns a new instance with the reversed ordering (before it changed the ordering for current instance).
This caused a bug which broke the ordering at exactly this location

persistence-utils/persistence-utils/src/com/axonivy/utils/persistence/dao/GenericDAO.java

Line 1521 in df344d2

orders.stream().forEach(o -> o.reverse());

Expected behavior
The set sorting is considered instead of always being ascending