Support of Sort.NullHandling from Spring

[mikoaj-pe]

Hi
I don't know if you are aware of this, but the findPage(pageable: Pageable) method does not fully cope with Sort from Spring. It manages to pass the direction and parameter name to the query, but loses information about NullHandling somewhere (NULLS_LAST etc.). So when I build Pageable with Sort looking like Sort.by(Order(DESC, "createdAt", NULLS_LAST)) - in query I only see "order by *.createdAt desc"

So I don't know if it's a bug or not yet implemented feature but I just want to let you know

[shouwn]

Hi mikoaj-pe.

I didn't realize this didn't work, my guess is that Spring doesn't support nulls_first or nulls_last yet.
spring-projects/spring-data-jpa#1280

When I looked at the code in Spring, it also didn't support this yet.

Probably because the Criteria API does not yet define interfaces for nulls_first or nulls_last.

Since Spring doesn't support it, it's unlikely that Kotlin JDSL will support it either.

If you want to use nulls_first or nulls_last, I recommend using the nullsFirst and nullsLast methods provided by Kotlin JDSL to handle them.

[shouwn]

I'll close this issue as there is no further conversation, but please reopen it if you need to discuss further.