Debian Codegraph @

mysql-test/suite/vcol/r/rpl_vcol.result

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