Bug #85656 Generated Columns
Submitted: 27 Mar 2017 18:36 Modified: 27 Mar 2017 19:49
Reporter: Brian Harrison-Dorval Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.9 OS:MacOS (macOS 10.12.x Sierra x86_64)
Assigned to: CPU Architecture:Any
Tags: generated columns, WBBugReporter

[27 Mar 2017 18:36] Brian Harrison-Dorval 
Description:
I've create a generated columns, but after when I do an alter table I get this error:
"There was an error while parsing the DDL retrieved from the server.
Do you want to view the DDL or cancel processing it?"

Here's the DDL:

delimiter $$

CREATE TABLE `testing` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `description` varchar(45) DEFAULT NULL,
  `test` varchar(45) AS (concat(name, ' ', description)) VIRTUAL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8$$

Database MariaDB 5.5.52-MariaDB

How to repeat:
Create a table with a generated column and try to alter it.
[27 Mar 2017 19:49] MySQL Verification Team 
Thank you for the bug report. The server you are using isn't supported.