| 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: | |
| 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 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
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 ')'