Bug #89053 Define a column that includes fsp cause "Alter Table Panel" render incomplete
Submitted: 26 Dec 2017 4:12 Modified: 15 Mar 2018 18:52
Reporter: johnny Mo Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.10 OS:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[26 Dec 2017 4:12] johnny Mo
Description:
When I defined a table that includes a column with fractional seconds part.Then I found that it caused the "Alter Table Panel" render incomplete. Those columns which defined after the column that includes fractional seconds part are not be render.

How to repeat:
1)create table that includes a column with fractional seconds part.As shown below, the column 'sent_at' was defined included fsp.

CREATE TABLE `c_tmp_fsp` (
  `id` char(32) NOT NULL,
  `sent_at` timestamp(6),
  `msgid_client` char(36),
  `msgid_server` char(36),
  `from_client_type` char(16),
  `from_device_id` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

2) Foucus on Navigator, locate the table, right click, chosen 'Alter Table...'.
  And you wil find that columns after `send_at` are not be render.

Suggested fix:
Those columns which defined after the column that includes fractional seconds part should be render!
[26 Dec 2017 5:55] Umesh Shastry
Hello johnny Mo,

Thank you for the report.
Verified as described on Win7 with MySQL Workbench Community (GPL) for Windows version 6.3.10 CE build 12092614 (64 bit).

Thanks,
Umesh
[15 Mar 2018 18:52] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.11 release, and here's the changelog entry:

Columns of a table that followed a column containing a fractional seconds
part did not appear within the tab opened by using Alter Table.

Thank you for the bug report.