--source include/have_innodb.inc

SET @@system_versioning_alter_history = 1;

create table t1 (a int not null, key(a))engine=innodb with system versioning;

create table t2 (b int, foreign key(b) references t1(a))engine=innodb with system versioning;

alter table t2 modify column b int default null;

drop table t2,t1;

create table t1 (a int, key(a))engine=innodb with system versioning;

create table t2 (b int, foreign key(b) references t1(a))engine=innodb with system versioning;

alter table t2 modify column b int not null;

drop table t2,t1;

mysqltest: At line 17: query 'alter table t2 modify column b int not null' failed: 1832: Cannot change column 'b': used in a foreign key constraint 't2_ibfk_1'