Bug #86906 Cannot edit foreign keys/indexes/view primary keys
Submitted: 3 Jul 2017 14:16 Modified: 4 Jul 2017 7:11
Reporter: Brian Leishman Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.9 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[3 Jul 2017 14:16] Brian Leishman
If the default expression for a table is "NULL ON UPDATE CURRENT_TIMESTAMP(6)", loading the table in the table editor is quite broken.

Looks like it can't parse that string, so anything after that in the "show create table" doesn't get considered anymore, so you can't view current indexes or foreign keys, etc. Also, it shows up as "ON UPDATE CURRENT_TIMESTAMP()" in the table editor once loaded. This may also affect columns after this column, but I have not tested that.

How to repeat:
put "NULL ON UPDATE CURRENT_TIMESTAMP(6)" into any column's "Default/Expression"
[4 Jul 2017 7:11] Umesh Shastry
Hello Brian,

Thank you for the report.