mysql-test/suite/gcol_ndb/t/gcol_virtual.test
raw| 1 | --source include/have_ndb.inc |
| 2 | |
| 3 | create table pear(x int primary key) engine=ndbcluster; |
| 4 | create table lemon(a int primary key, |
| 5 | v int generated always as (a+1) virtual, |
| 6 | x int, |
| 7 | y int, |
| 8 | foreign key (x) references pear(x)) engine=ndbcluster; |
| 9 | --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON |
| 10 | alter table lemon algorithm=inplace, rename column x to z; |
| 11 | show warnings; |
| 12 | alter table lemon algorithm=inplace, rename column y to w; |
| 13 | drop tables lemon,pear; |