Bug #74617 Timestamp with microseconds not supported in synchronization
Submitted: 29 Oct 2014 11:42 Modified: 4 Nov 2014 16:10
Reporter: Davide Prade Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.2.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: microseconds, TIMESTAMP(6)

[29 Oct 2014 11:42] Davide Prade
In EER diagram the function "Database-->Synchronize with Any Source" doesn't works with "TIMESTAMP(6)" columns.

How to repeat:
Open an EER diagram and click on "Database-->Synchronize with Any Source" menu item.

Select "NEW.sql" as source script file.
Select "OLD.sql" as destination script file.
Select "diff.sql" as ALTER script File.
Generate the ALTER script file with the wizard.

The program generate a wrong CREATE TABLE statement without the microsecond column specifications.
[29 Oct 2014 11:43] Davide Prade
Source script

Attachment: NEW.sql (application/octet-stream, text), 706 bytes.

[29 Oct 2014 11:43] Davide Prade
Destination script

Attachment: OLD.sql (application/octet-stream, text), 400 bytes.

[29 Oct 2014 11:44] Davide Prade
ALTER script

Attachment: diff.sql (application/octet-stream, text), 734 bytes.

[4 Nov 2014 16:10] Miguel Solorzano
Thank you for the bug report.
[27 Oct 2016 11:04] Miguel Solorzano
http://bugs.mysql.com/bug.php?id=83490 marked as duplicate of this one.