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