2
create table bug53592(a int) engine=innodb row_format=compact;
3
alter table bug53592 add column b text charset utf8;
4
alter table bug53592 add column c blob not null;
5
create index bug53592_b on bug53592(b(81));
6
create unique index bug53592_c on bug53592(c(1));
7
replace into bug53592 values (),();
9
Warning 1364 Field 'c' doesn't have a default value
11
Table Op Msg_type Msg_text
12
test.bug53592 check status OK
14
set old_alter_table=1;
15
create table bug53592(a int) engine=innodb row_format=compact;
16
alter table bug53592 add column b text charset utf8;
17
alter table bug53592 add column c blob not null;
18
create index bug53592_b on bug53592(b(81));
19
create unique index bug53592_c on bug53592(c(1));
20
replace into bug53592 values (),();
22
Warning 1364 Field 'c' doesn't have a default value
24
Table Op Msg_type Msg_text
25
test.bug53592 check status OK