Debian Codegraph @

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

raw
1 create table pear(x int primary key) engine=ndbcluster;
2 create table lemon(a int primary key,
3 v int generated always as (a+1) virtual,
4 x int,
5 y int,
6 foreign key (x) references pear(x)) engine=ndbcluster;
7 alter table lemon algorithm=inplace, rename column x to z;
8 ERROR 0A000: ALTER TABLE is not supported. Reason: Altering name of a field being referenced from a foreign key is not supported. Try dropping foreign key first.
9 show warnings;
10 Level Code Message
11 Error 1846 ALTER TABLE is not supported. Reason: Altering name of a field being referenced from a foreign key is not supported. Try dropping foreign key first.
12 alter table lemon algorithm=inplace, rename column y to w;
13 drop tables lemon,pear;