Bug #92693 Reverse Engineer Database ignores DATETIME fsp

• Submitted: 5 Oct 2018 15:19
• Modified: 5 Oct 2018 17:47
• Reporter: Christian Sleight
• Status: Verified
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.12
• OS: Microsoft Windows
• CPU Architecture: Any

[5 Oct 2018 15:19] Christian Sleight

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)

[5 Oct 2018 17:47] Miguel Solorzano

Thank you for the bug report.