Virtuality is not selected when editing generated column

[linaspasv]

When trying to edit a generated column, a correct virtuality option is not being picked from a dropdown. I have not tested other version but latest 5.0.0-dev is affected.

[bahl24]

@linaspasv Can you elaborate testing instructions or provide screenshots?

[linaspasv]

So I got a generated column on table and when I try on change it, the dropdown for virtuality is empty in edit page (it should have been selected as persistant in my case). Also, I have tested on the latest stable release and the same problem is there aswell.

I hope it helps, let me know if you need more details.

[bahl24]

@linaspasv I was able to reproduce the issue and found that virtuality is missing but expression is prefilled.

[linaspasv]

@bahl24 correct, the expression is here but virtuality option is not being selected from the dropdown. But when virtuality is not being pre-selected and you click on save, phpmyadmin alters column to a regular one. In my case, this led to accidental overwrite of a generated column.

[bahl24]

@linaspasv Which database server are you using, MySQL or MariaDB?

[linaspasv]

@bahl24 I am using MariaDB 10.3 . I have not tested with MySQL.

[bahl24]

@linaspasv Kindly check

[linaspasv]

@bahl24 I have tested the change and it works perfectly. Very good job, thanks!