bq. Otherwise put, the issue here is that the datetime type used by hibernate for mysql / mariadb for the "timestamp" hibernate mapping is not migrated automatically to datetime(6) upon upgrade of XWiki.
It's not very clear what XWiki versions/setups did have a datetime type without fractions(so that they can be impacted by the lack of migration) but we know a couple of things:
* it seems mysql / mariadb specific, other db engines have fractions in the types mapped to hibernate's "timestamp" type by default (e.g. postgres)
* I reproduced it for servers with MySQL 5.7 and 5.x connector, for XWiki versions up to 11.10
* I did not reproduce it for servers with Mysql 8+ and 8.x connector, starting from XWiki versions 12.10 and higher
However, I didn't test on an instance of XWiki 12.10 with mysql 5.x because I didn't have one available, as we started having mysql 8 for more recent versions of XWiki. I don't know if it could happen as well or not for versions above 12 . 10.
I also did not test an XWiki < 11.10 with a mysql 8 engine & driver, because I didn't have one either. |
|
