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
• Status: Closed
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 6.3.10
• OS: Windows (Microsoft Windows 10 Pro)
• 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] MySQL Verification Team

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.