Null boolean value on generated countBy with where clause query

[ben-dale]

We recently tried to upgrade one of our projects from springboot 2.6.3 to 2.6.4 (upgrading spring-data-r2dbc:1.4.1 to spring-data-r2dbc:1.4.2), which introduced an interesting error that we believe stems from this project 🤔

We have an interface:

interface XYZRepository : CoroutineCrudRepository<XYZ, UUID> {
    suspend fun countByAvailabilityTrue(): Int
}

We turned on logging using the r2dbc logging application properties to see what query was being generated:

logging.level.io.r2dbc.postgresql.QUERY=DEBUG
logging.level.io.r2dbc.postgresql.PARAM=DEBUG

Before upgrading to springboot 2.6.3 (spring-data-r2dbc:1.4.1):

{"message":"Executing query: SELECT COUNT(xyz.user_id) FROM xyz WHERE xyz.availability = TRUE","status":"DEBUG"}

After upgrading to springboot 2.6.4 (spring-data-r2dbc:1.4.2):

{"message":"Bind parameter [0] to null, type: java.lang.Boolean","status":"DEBUG"}
{"message":"Executing query: SELECT COUNT(xyz.user_id) FROM xyz WHERE xyz.availability = $1","status":"DEBUG"}

Notice after the upgrade, the boolean parameter is being forcibly set to null.

We understand from the documentation here and here that our usage should be valid.

Apologies in advance if this is not the correct project to raise this issue in. Thanks!

[mp911de]

This is a duplicate of #733. Care to upgrade to the latest snapshots of Spring Data R2DBC and retry to confirm that the bugfix works for you?