MySQL Bugs: #89053: Define a column that includes fsp cause "Alter Table Panel" render incomplete

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:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

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!

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

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.