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; |