blob: da56772bf6032dcfa295fd2c2e475da1e2ef48e5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
--echo #
--echo # BUG#6236 - ALTER TABLE MODIFY should set implicit NOT NULL on PK columns
--echo #
create table t1 ( a varchar(10) not null primary key ) engine=myisam;
create table t2 ( a varchar(10) not null primary key ) engine=merge union=(t1);
flush tables;
alter table t1 modify a varchar(10);
show create table t2;
flush tables;
alter table t1 modify a varchar(10) not null;
show create table t2;
drop table if exists t1, t2;
|
