MySQL Bugs: #104417: Fractional DATETIME precision omitted in CREATE script when synchronizing

Bug #104417	Fractional DATETIME precision omitted in CREATE script when synchronizing
Submitted:	26 Jul 2021 10:59	Modified:	26 Jul 2021 13:16
Reporter:	Manuel Ruetz	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.26	OS:	Windows
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Precision of fractional seconds in DATETIME columns gets lost when synchronizing the schema. The ALTER / CREATE script Workbench generates does not contain any information about it. 

DB connection does recognize target server version correctly (8.0.25). Also, both version settings, the model and default preferences has been set to 8.0

How to repeat:
Create new table, add a DATETIME(6) column. Synchronize model and follow the wizard until the create script is shown. Check DDL for the table.

Hello Manuel Ruetz,

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

Regards,
Ashwini Patil