Editting virtual columns

[unix4you2]

Hi!

When you have virtual columns (calculated) in your table you cant edit them with the option "Alter table"

Steps to reproduce:

1. Create a table with VIRTUAL columns like this:

CREATE TABLE `my_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  `priority` varchar(20) NOT NULL,
  `clasification` varchar(50) NOT NULL,
  `clasification_plus_type` varchar(255) GENERATED ALWAYS AS (concat(`clasification`,': ',`type`)) VIRTUAL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

2. Try to use the "Alter table" option in Adminer
3. You cant update or change how the column is calculated

Best regards

[vrana]

I couldn't reproduce it. Please describe “cant update or change” and attach some screenshots.