diff options
| author | antony@ltantony.mysql.com <> | 2005-05-08 21:03:50 +0100 |
|---|---|---|
| committer | antony@ltantony.mysql.com <> | 2005-05-08 21:03:50 +0100 |
| commit | d51308aec443aea67a0287abb7486190c8913fee (patch) | |
| tree | 8bff4a045bfee136d2e6aafee2ea685fbadee4ba /mysql-test/r/alter_table.result | |
| parent | bc27c14ea924b0e11ad21d38c69e3afe56a6e151 (diff) | |
| download | mariadb-git-d51308aec443aea67a0287abb7486190c8913fee.tar.gz | |
Bug#6236
Incomplete ALTER TABLE breaks MERGE compatibility
Fix implicit NOT NULL not set on ALTER of PK columns
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 78925a64e93..80d3ef5e0a5 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -386,3 +386,23 @@ Incorrect table name 't1\\' rename table t1 to `t1\\`; Incorrect table name 't1\\' drop table t1; +drop table if exists t1, t2; +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; +Table Create Table +t2 CREATE TABLE `t2` ( + `a` varchar(10) NOT NULL default '', + PRIMARY KEY (`a`) +) TYPE=MRG_MyISAM UNION=(t1) +flush tables; +alter table t1 modify a varchar(10) not null; +show create table t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `a` varchar(10) NOT NULL default '', + PRIMARY KEY (`a`) +) TYPE=MRG_MyISAM UNION=(t1) +drop table if exists t1, t2; |