Bug #90492 MySQL Workbench does not render ALTER TABLE UI when table has CHECK constraints
Submitted: 18 Apr 2018 10:00 Modified: 18 Apr 2018 10:14
Reporter: Robert Orakel Buchholz Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3 OS:Any
Assigned to: CPU Architecture:Any

[18 Apr 2018 10:00] Robert Orakel Buchholz 
Description:
When connecting to a Database with a check constraint, the "Alter Table" Option throws a "bad cast" Error.

How to repeat:
Connect to a Database Server that supports CHECK constraints (MariaDB 10.2.13 in my case).

Create a Table with the following Schema:

show create table question;

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
...
  PRIMARY KEY (`id`),
...
...
  CONSTRAINT `abc_def` CHECK (`fnord` in (0,1))
) ENGINE=InnoDB AUTO_INCREMENT=2767 DEFAULT CHARSET=utf8mb4

Connect to the Database with Workbench and select "Alter Table".
[18 Apr 2018 10:01] Robert Orakel Buchholz 
Screenshot showing the problem

Attachment: Zwischenablage04.png (image/png, text), 61.64 KiB.
[18 Apr 2018 10:14] MySQL Verification Team 
Thank you for the bug report. MariaDB isn't supported by WorkBench.