1create database mysqltest1;
2create table mysqltest1.t1 (i int, j int as (i) persistent);
3show create table mysqltest1.t1;
4Table	Create Table
5t1	CREATE TABLE `t1` (
6  `i` int(11) DEFAULT NULL,
7  `j` int(11) GENERATED ALWAYS AS (`i`) STORED
8) ENGINE=MyISAM DEFAULT CHARSET=latin1
9alter table mysqltest1.t1 add index (i);
10show create table mysqltest1.t1;
11Table	Create Table
12t1	CREATE TABLE `t1` (
13  `i` int(11) DEFAULT NULL,
14  `j` int(11) GENERATED ALWAYS AS (`i`) STORED,
15  KEY `i` (`i`)
16) ENGINE=MyISAM DEFAULT CHARSET=latin1
17drop database mysqltest1;
18