I am using blaze persistence (version 1.6.14) for fetching entities from my database. An SqlGrammarExcepion is thrown with the message

com.microsoft.sqlserver.jdbc.SQLServerException: A column has been specified more than once in the order by list. Columns in the order by list must be unique.

when calling the following method:

@Override
public List<CurrencyView> findAllCurrencies(CurrencyCriteria currencyCriteria, Sort sort) {

var settings = EntityViewSetting.create(CurrencyView.class);
var cb = criteriaBuilderFactory.create(entityManager, Currency.class);


for (Sort.Order order : sort) {
  String property = order.getProperty();
  Sorter sorter = order.getDirection() == Sort.Direction.ASC ? Sorters.ascending() : Sorters.descending();
  settings.addAttributeSorter(property, sorter);
}

return entityViewManager.applySetting(settings, cb).getResultList();
}

The error is thrown when the getResultList() method is called. I have checked multiple times. The Sort object contains the "duplicated" parameter exactly once.

When I checked the generated query, I saw that it looks like this:

ORDER  BY CASE WHEN ( CASE WHEN c1_0.currency_order IS NULL THEN 1 ELSE 0 END ) IS NULL THEN 1 ELSE 0 END,
          CASE WHEN   c1_0.currency_order   IS NULL THEN 1 ELSE 0 END,
          CASE WHEN ( c1_0.currency_order ) IS NULL THEN 1 ELSE 0 END,
          c1_0.currency_order,
          CASE WHEN ( c1_0.code ) IS NULL THEN 1 ELSE 0 END,
          c1_0.code 

I have tried different ways of writing the sorting part so that it would work fine, but I always get the same result. Any suggestions?