ORM is producing incorrect sql for creating a datetime column with default CURRENT_TIMESTAMP

[glenelkinsdev]

I've just ran into a strange problem that i've never had with doctrine before.

I have an application in symfony 5 using doctrine orm entities, i have used a datetime column with CURRENT_TIMESTAMP as the default many many times and i've never had this issue before.

Take this field:

/**
     * @ORM\Column(type="datetime", options={"default":"CURRENT_TIMESTAMP"})
     */
private $dateTime;

And now when i run the schema update it would usually create the table no problem, but now i'm getting:

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'date_time'

The sql that doctrine is creating:

CREATE TABLE user_block (id INT AUTO_INCREMENT NOT NULL, blocking_user_id INT DEFAULT NULL, blocked_user_id INT DEFAULT NULL, date_time DATETIME(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, reason LONGTEXT NOT N  
  ULL, deleted TINYINT(1) DEFAULT '0' NOT NULL, deleted_date_time DATETIME(6) DEFAULT NULL, INDEX IDX_61D96C7AF90D76D (blocking_user_id), INDEX IDX_61D96C7A1EBCBB63 (blocked_user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb  
  4_unicode_ci` ENGINE = InnoDB

The problem seems to be the datetime precision which is set to 6, DATETIME(6) but doctrine isn't using CURRENT_TIMESTAMP(6) so this error is happening.

This code i have used for about a year with no problem, but then i came to rebuild the tables with a schema update on php 5.7 (same as before) and now all of a sudden it's doing this.

[glenelkinsdev]

To add, i had to create a migration and manually change the query to work properly