MySQL Bugs: #92693: Reverse Engineer Database ignores DATETIME fsp

Bug #92693	Reverse Engineer Database ignores DATETIME fsp
Submitted:	5 Oct 2018 15:19	Modified:	5 Oct 2018 17:47
Reporter:	Christian Sleight	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.12	OS:	Windows
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When you reverse engineer a database that includes fields with DATETIME(3) fsp the resulting models have a DATETIME(0) fsp. When you generate a Forward Engineer script, the schema will then have DATETIME fields instead of DATETIME(3) fields. 

How to repeat:
CREATE SCHEMA `test` ;

CREATE TABLE `test`.`new_table` (
  `my_date` DATETIME(3) NULL);

Workbench > Database > Reverse Engineer > select test database

EER Diagram shows DATETIME not DATETIME(3)

Workbench > File > Export > Forward Engineer SQL CREATE Script...

script shows DATETIME not DATETIME(3)

Thank you for the bug report.