Debian Codegraph @

mysql-test/suite/gcol_ndb/t/gcol_stored_basic_ddl.test

raw
1 ################################################################################
2 #
3 # Test GENERATED ALWAYS AS ... STORED
4 # CREATE TABLE
5 # ALTER TABLE add generated column
6 # ALTER TABLE drop generated column
7 ################################################################################
8
9 --source include/have_ndb.inc
10
11 create table t (i int not null primary key) engine='ndbcluster';
12
13 insert into t values(1), (2), (3);
14
15 alter table t add j int generated always as (10+i) stored;
16
17 select * from t order by i;
18
19 insert into t(i) values (4), (5);
20
21 select * from t order by i;
22
23 select * from t where j = 14;
24
25 alter table t drop j;
26
27 select * from t order by i;
28
29 drop table t;