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