Bug #90350 Unable to see table with generated columns in fk referenced column list
Submitted: 9 Apr 2018 12:50 Modified: 9 Apr 2018 13:45
Reporter: Krish KM Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.10, 8.0.20 OS:Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to: CPU Architecture:Any (x64)
Tags: WBBugReporter

[9 Apr 2018 12:50] Krish KM
Fields/columns are not shown for selection when adding foreign keys via workbench gui, when the referenced table contains any "Generated virtual" columns.

How to repeat:
Create two tables with any fields and one table with at least one "generted virtual column"

now try to add foreign key from Table1 => tableWithGeneratedColumn using Workbench gui.

the "referenced column" dropdown is empty and has "Specify column".

If you remove the "generated column" from the table "tableWithGeneratedColumn", fields are visible to select.
[9 Apr 2018 13:45] Chiranjeevi Battula
Hello Krish,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 6.3.10 version.

[9 Apr 2018 13:46] Chiranjeevi Battula

Attachment: Bug_90350.png (image/png, text), 124.19 KiB.

[9 Apr 2018 22:25] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=90356 marked as duplicate of this one.
[9 May 2018 12:43] Miguel Tadeu Mota
Posted by developer:
At the moment, it only happens on macos
[9 May 2018 12:46] Miguel Tadeu Mota
Posted by developer:
Please ignore the last comment
[12 Jun 2020 9:52] MySQL Verification Team
Bug #99555 marked as duplicate of this one.