Debian Codegraph @

mysql-test/suite/gcol/r/rpl_gcol.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 generated always as (a+1) virtual);
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 DROP VIEW IF EXISTS v1,v2;
27 DROP TABLE IF EXISTS t1,t2,t3;
28 DROP PROCEDURE IF EXISTS p1;
29 DROP FUNCTION IF EXISTS f1;
30 DROP TRIGGER IF EXISTS trg1;
31 DROP TRIGGER IF EXISTS trg2;
32 set sql_warnings = 0;
33 include/rpl_end.inc