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:
None 
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 
Description:
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.

Thanks,
Chiranjeevi.
[9 Apr 2018 13:46] Chiranjeevi Battula 
Screenshot

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.