Debian Codegraph @

mysql-test/suite/gcol_ndb/r/gcol_stored_basic_ddl.result

raw
1 create table t (i int not null primary key) engine='ndbcluster';
2 insert into t values(1), (2), (3);
3 alter table t add j int generated always as (10+i) stored;
4 select * from t order by i;
5 i j
6 1 11
7 2 12
8 3 13
9 insert into t(i) values (4), (5);
10 select * from t order by i;
11 i j
12 1 11
13 2 12
14 3 13
15 4 14
16 5 15
17 select * from t where j = 14;
18 i j
19 4 14
20 alter table t drop j;
21 select * from t order by i;
22 i
23 1
24 2
25 3
26 4
27 5
28 drop table t;