R2dbcEntityTemplate does not support null insertion into a column that has a default value

[nihsmik]

There is no way to insert null into a column that has a default value. R2dbcEntityTemplate.doInsert excludes null-valued columns.

[mp911de]

This is by design. We expect that the database fills in null values. What is the background of this ticket? Do you have a case where you want to set null values?

[nihsmik]

Thanks for your comment!

I have a column named updated_at like the following:
updated_at timestamp default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP

I noticed that when using the update function, it tries to apply null to the column. On the other hand, the insert function does not. I was curious as to why these functions work differently, although I know that @LastModifiedDate is the best practice in this case.

[mp911de]

We expect that a column defaults to null when it is being omitted from an INSERT. On UPDATE, we want to reflect the state of a null values. Not including a column whose value was set to null in an UPDATE leaves the value unchanged.

If you want to suppress sending null for a property, then annotate it with @ReadOnlyProperty. It will not be included in inserts or update statements.

[nihsmik]

This is exactly the answer I needed! 😀
I want to thank you again for your time and helpful responses.