Bug #89502 MySQL Workbench doesn't display all columns in table editor

• Submitted: 1 Feb 2018 20:25
• Modified: 2 Feb 2018 5:33
• Reporter: Admir Ramic
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 6.3.10 CE (64 bits)
• OS: Windows (Windows 10)
• CPU Architecture: Any
• Tags: columns, display, table editor

[1 Feb 2018 20:25] Admir Ramic

Description:
Columns unitil the column with datatype DATETIME(6) and Expression "CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP()" are displayed. Columns after this column are not displayed in the table editor.

How to repeat:
create following table and open the table editor:

CREATE TABLE `User` (
  `UserId` bigint(20) NOT NULL AUTO_INCREMENT,
  `AccessFailedCount` smallint(6) NOT NULL,
  `AccessToken` longtext DEFAULT NULL,
  `DateCreated` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `DateEdited` datetime(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `DateLoggedIn` datetime(6) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `EmailConfirmed` bit(1) NOT NULL,
  `Firstname` varchar(100) DEFAULT NULL,
  `LockoutEnd` datetime(6) NOT NULL,
  `MobileNr` varchar(50) DEFAULT NULL,
  `Password` longtext NOT NULL,
  `Surname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[2 Feb 2018 5:33] MySQL Verification Team

Hello Admir Ramic,

Thank you for the report.
This is most likely duplicate of Bug #88367, please see Bug #88367

Thanks,
Umesh