createdAt field annotated with @CreationDate gets updated when an entity is modified. [using spring boot 3.0.4]

[isatishp]

When an entity is modified, we see that created time gets updated. This happens with newly created entity, for older entities it works fine.

Steps to reproduce:

1. Create an entity which has fields annotated with @CreatedDate @ModifiedDate and @EntityListeners(AuditingEntityListener.class)
2. Save the entity using JPA Repository class
3. Update the entity
4. And, you see updated entity has creationDate from the future

[schauder]

Please provide a Minimimal Reproducable Example, preferable as a Github repository. Make sure to include the database, either as an in memory database or if that is not possible using Testcontainers.

[isatishp]

Hi I tried an example using embedded DB and I could not reproduce this issue with in memory DB. However, the moment I switched to Postgres which is also the db we use, I could reproduce the issue.. Unfortunately I do not know how to do an implementation with Test Containers.. But I have a working example here that reproduces the issue.

https://github.com/isatishp/student-crud

[isatishp]

Also, the modified timestamp is saved in local timezone which was not the case with sprint boot v2.7.9. I tried 3.0.4 with postgres version used in v2.7.9 which is postgres:42.3.8 and is still reproducible.

[schauder]

I tried to create a reproducer out of your repository but failed.

I created a PR which introduces a test using Testcontainers and removes the stuff that shouldn't have anything to do with the described problem.

Please modify that version of the reproducer to actually reproduce the original issue.

Please create separate issue for the second problem about the timezone issue.