MySQL Bugs: #79360: MySQL Workbench won't remember the type of generated column for stored columns

Bug #79360	MySQL Workbench won't remember the type of generated column for stored columns
Submitted:	20 Nov 2015 11:44	Modified:	20 Dec 2015 14:59
Reporter:	Ya T	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.5 (64-bit)	OS:	Windows (10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	generated column, stored, type, workbench

Description:
If you create a stored generated column and after that try to amend it the Workbench GUI will think that the generated column is virtual rather than stored. The generated SQL will return an error saying that changing type of generated columns is not allowed.

How to repeat:
1. Create a stored generated column and submit changes.

2. Try doing a change to the column in a table properties (open table properties using a wrench sign for the table), for example change the calculation formula or the order of the column in the table by dragging it to a different position.
== On this step you will see that in the bottom tight part of the properties editor the column is shown as Virtual.

3. Try applying the changes.
== On this step you will be given an error: 'Changing the STORED status' is not supported for generated columns.

However, this seems to work only for certain generated columns (the first one from the beginning of the table?)

Hello!

Thank you for the report.
I'm not seeing this issue with dummy schema on win7 with WB 6.3.5, could you please provide exact repeatable test case and/or screenshot? You may want to mark it as private after uploading.

Thanks,
Umesh

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".