Bug #83490 MWB missing when precision is set on "ON UPDATED" option.
Submitted: 24 Oct 2016 1:44 Modified: 27 Oct 2016 11:03
Reporter: 희원 이 Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.3.8 OS:Any
Assigned to: CPU Architecture:Any
Tags: datetime, MICROSECOND, on updated, timestamp

[24 Oct 2016 1:44] 희원 이
Description:
MWB missing when precision is set on "ON UPDATED" option.

How to repeat:
1. I make a column with "ts TIMESTAMP(2) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(2)"

2. MWB reverse engineering, then make "TIMESTAMP(2) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP()"
so, last precision value is missing.

OR

3. If you synchronize DB, infinitely try to repeat altering the `ts` column with same options.
[24 Oct 2016 9:24] Miguel Solorzano
Please try version 6.3.8. Thanks.
[25 Oct 2016 1:46] 희원 이
I just tested on 6.3.8, and same issue is occurred.
[27 Oct 2016 11:03] Miguel Solorzano
Duplicate/related with http://bugs.mysql.com/bug.php?id=74617.