Michel Tournay

I everyone @erikellsinger it's seems to be an old doctrine issue of not supporting milliseconds https://github.com/doctrine/dbal/issues/2873 I run a mariadb 10.5 too, and i'd like to know if it's possible...

Hi there @erikellsinger I did it ! I had to cast to datetime manually in code file GetElasticsearchProductProjection.php line 133 `CAST(GREATEST(product.updated, IFNULL(sub_product_model.updated, 0), COALESCE(root_product_model.updated, 0)) AS DATETIME(0)) AS updated_date,` file...

Hi according to the response in this thread, it's not a bug https://jira.mariadb.org/browse/MDEV-4560?jql=text%20~%20%22greatest%20datetime%22

Hi indeed you're right : forcing type resolves issue, and it's what i did explain here https://github.com/akeneo/pim-community-dev/issues/17711 This is a huge difference between mysql/maria, and honestly I don't know what...