set old_alter_table=0;
create table bug53592(a int) engine=innodb row_format=compact;
alter table bug53592 add column b text charset utf8;
alter table bug53592 add column c blob not null;
create index bug53592_b on bug53592(b(81));
create unique index bug53592_c on bug53592(c(1));
replace into bug53592 values (),();
Warnings:
Warning	1364	Field 'c' doesn't have a default value
check table bug53592;
Table	Op	Msg_type	Msg_text
test.bug53592	check	status	OK
drop table bug53592;
set old_alter_table=1;
create table bug53592(a int) engine=innodb row_format=compact;
alter table bug53592 add column b text charset utf8;
alter table bug53592 add column c blob not null;
create index bug53592_b on bug53592(b(81));
create unique index bug53592_c on bug53592(c(1));
replace into bug53592 values (),();
Warnings:
Warning	1364	Field 'c' doesn't have a default value
check table bug53592;
Table	Op	Msg_type	Msg_text
test.bug53592	check	status	OK
drop table bug53592;
