app throws "Applying Null Precedence using Criteria Queries is not yet supported." exception in v3.4.0 but works with v3.3.6

[kctang]

I'm migrating a spring boot v2.7.x app to v3.4.0 At runtime, i'm getting "Applying Null Precedence using Criteria Queries is not yet supported." exception thrown.

spring-data-jpa/spring-data-jpa/src/main/java/org/springframework/data/jpa/repository/query/QueryUtils.java

Line 757 in 7f13a04

throw new UnsupportedOperationException("Applying Null Precedence using Criteria Queries is not yet supported.");

The exception was thrown when trying to execute my repository interface's method that looks something like Page<Xxx> findByXxxAndYyy(String xxx, yyy, Pageable pageable);.

I tried to switch to spring boot v3.3.6 and the app works without issue, so only seems to affect v3.4.0.

I placed a comment in a related issue.

Looks like a bug to me.

Thanks for reading & hope this issue can be solved soon.

[mp911de]

Null precedence wasn't ever supported using Criteria Queries because JPA doesn't specify (until JPA 3.2) the necessary API. We just never raised awareness that this isn't working. We consider leniently accepting and silently dropping sort definitions a potential source of bugs that easily goes unnoticed. Therefore, we introduced an exception to alert you that the intended null sorting behavior isn't available. If you do not specify null precedence, then the exception goes away.

[mp911de]

Closing as duplicate of #1280. Null precedence will come with Spring Data JPA 4.0.