1SET @@session.default_storage_engine = 'InnoDB';
2include/master-slave.inc
3[connection master]
4connection master;
5create table t1 (a int, b int generated always as (a+1) virtual);
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;
26DROP VIEW  IF EXISTS v1,v2;
27DROP TABLE IF EXISTS t1,t2,t3;
28DROP PROCEDURE IF EXISTS p1;
29DROP FUNCTION IF EXISTS f1;
30DROP TRIGGER IF EXISTS trg1;
31DROP TRIGGER IF EXISTS trg2;
32set sql_warnings = 0;
33include/rpl_end.inc
34