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:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.12	OS:	Windows
Assigned to:		CPU Architecture:	Any

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.

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.