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; |