Bug #110700 Synchronize Mode with Database fails for DATETIME(6)
Submitted: 14 Apr 2023 16:45 Modified: 17 Apr 2023 7:06
Reporter: Ronny H. Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.32 OS:Windows (10)
Assigned to: CPU Architecture:Any
Tags: datetime

[14 Apr 2023 16:45] Ronny H.
Description:
Define a table column `xxx` DATETIME NOT NULL DEFAULT now(6) in WB. Then Synchronize Mode with Database. Fails with ERROR: Error 1067: Invalid default value for 'xxx'.

Please see screenshots.

How to repeat:
See desc.
[14 Apr 2023 16:56] Ronny H.
MySQL Workbench Sync Model with DB

Attachment: 2023-04-14 18_30_47-MySQL Workbench.png (image/png, text), 510.91 KiB.

[14 Apr 2023 16:57] Ronny H.
Error

Attachment: 2023-04-14 18_31_04-Synchronize Model with Database.png (image/png, text), 88.45 KiB.

[17 Apr 2023 7:06] MySQL Verification Team
Hello Ronny,

Thank you for the bug report.
Imho this is duplicate of Bug #74617, please see Bug #74617.

Regards,
Ashwini Patil