Bug #107582 Reverse engineer with generated attributes
Submitted: 17 Jun 2022 5:24 Modified: 17 Jun 2022 6:14
Reporter: John King Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:8.0.27 OS:Any
Assigned to: CPU Architecture:Any
Tags: generated column, reverse engineer

[17 Jun 2022 5:24] John King
Description:
Reverse engineer a relation with a generated attribute

How to repeat:
1.create at table
CREATE TABLE `reverse`.`generated` (
  `ID` INT UNSIGNED NOT NULL,
  `firstname` VARCHAR(45) NULL,
  `lastname` VARCHAR(45) NULL,
  `fullname` VARCHAR(45) GENERATED ALWAYS AS (concat_ws("  ",firstname, lastname)) VIRTUAL,
  PRIMARY KEY (`ID`));

2.reverse engineer this
error reported:
ERROR: (3, 25) "GENERATED" is not valid at this position, expecting ')'
[17 Jun 2022 6:14] MySQL Verification Team
Hello John,

Thank you for the bug report.
Imho this is duplicate of Bug #92267, please see Bug #92267.

Regards,
Ashwini Patil