Debian Codegraph @

mysql-test/suite/merge/alter_table.test

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