MySQL auto_increment not returned after save()

[mindhaq]

As for almost all cases, the id of my entity will not be null, I want to define that field as such in Kotlin:

data class Entity (
    @Id
    val id: Long = 0 
)

When I save a new entity with repository's save() method, it gets INSERTed as expected, with a new id auto_generated by the database. However, the returned entity still has an id of 0, and not the generated value.

If I change the entity declaration with a null id, and use null as id for the new entity, this is not the case, and the returned entity has the new id.

data class Entity (
    @Id
    val id: Long? = null 
)

Experiments with implementing interface Persistable did not lead to different results.

[mindhaq]

I'm not sure, but it sounds similar to spring-projects/spring-data-relational#1274

[mp911de]

Auto-generated Id's should be returned by issuing Statement.returnGeneratedKeys(…) and then consuming the resultset to populate the Id. We need to investigate/debug what happens here.

[Tienisto]

After #444, non-nullable fields should be working in kotlin.
Did you test it in the latest snapshot?

[mp911de]

I wasn't able to reproduce the issue.
If you would like us to spend some time helping you to diagnose the problem, please spend some time describing it and, ideally, providing a minimal sample that reproduces the problem.

[mindhaq]

I just ran my test with spring-boot:2.4.0-M4 and spring-data-r2dbc:1.2.0-RC2 and it worked as expected.

Sorry for the duplicate.