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:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.12 OS:Windows
Assigned to: CPU Architecture:Any

[5 Oct 2018 15:19] Christian Sleight
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 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)
[5 Oct 2018 17:47] MySQL Verification Team
Thank you for the bug report.