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 did not reproduce it either for XWiki 12.10 with mysql 5 .x because I didn't have one available , as we started having mysql with Mysql 5.7 but with 8 for more recent versions of XWiki . I don't know if 0.22 connector, so it seems it could happen as well or not for versions above 12.10. be related to both the connector and to the XWiki version?
I also did not test an XWiki < 11.10 with a mysql 8 engine & driver, because I didn't have one either . |
|
