1SET @@session.default_storage_engine = 'InnoDB';
2include/master-slave.inc
3[connection master]
4connection master;
5create table t1 (a int, b int as (a+1));
6show create table t1;
7Table	Create Table
8t1	CREATE TABLE `t1` (
9  `a` int(11) DEFAULT NULL,
10  `b` int(11) GENERATED ALWAYS AS (`a` + 1) VIRTUAL
11) ENGINE=MyISAM DEFAULT CHARSET=latin1
12insert into t1 values (1,default);
13insert into t1 values (2,default);
14select * from t1;
15a	b
161	2
172	3
18connection slave;
19select * from t1;
20a	b
211	2
222	3
23connection master;
24drop table t1;
25connection slave;
26include/rpl_end.inc
27