Default null ordering not working [DATAJPA-1821]

[spring-projects-issues]

Swapnil Vaidya opened DATAJPA-1821 and commented

I have default null ordering property as 'last' in my Spring Boot Project

hibernate.order_by.default_null_ordering: last

This is not working for the database columns where datatype = text

in POSTGRESQL database.

---

No further details from DATAJPA-1821

[skrabbenborg]

How are you calling the repository when you want the sorting to occur? Since sorting is only applied when the method call actually requests sorting.

When I have the following in my application.properties:
spring.jpa.properties.hibernate.order_by.default_null_ordering=first

firstNames with value null are returned first when I call:
repository.findAll(Sort.by(Sort.DEFAULT_DIRECTION, "firstName"));

No sorting occurs when I call:
repository.findAll();

[schauder]

This is a duplicate of #1280 (JPA does not support NULL precedence)