MySQL Bugs: #103542: datatype DATETIME(3) not accept

Bug #103542	datatype DATETIME(3) not accept
Submitted:	30 Apr 2021 11:02	Modified:	30 Apr 2021 13:12
Reporter:	M Timmerman	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.24	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
In my EER diagram I put a field of type DATETIME(3) in a table.
When I synchronize with the database I get a field type DATETIME
When I use the SQL query: 
ALTER TABLE Device_Sensor modify Sensor_Data_Log_Tijdstip DATETIME(3);

I get the correct field in my table

How to repeat:
Make a default database with a default table.
Put a field of type DATETIME(3) in the table in the EER diagram.

Hello,

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

Regards,
Ashwini Patil