Hello!
I want add sort to pageable request to db postgres. I want add rule for null ordering.
For this I use
Sort.Order order = new Sort.Order(ASC, "sortString", Sort.NullHandling.NULLS_LAST);
val pageable = PageRequest.of(0, 100, Sort.by(order));
sortEntityRepository.findAll(pageable);
But when I look to SQL request
order by sortentity0_.sort_string asc limit
I don’t find nulls last.
but when I add property
order_by.default_null_ordering: last
this works correctly.
Tell me, is this normal behavior?