diff options
| -rw-r--r-- | mysql-test/r/multi_update.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/multi_update.test | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 233c99fb22b..d286b01c1c7 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -336,7 +336,7 @@ alter table t1 add b char(8) not null; alter table t1 add a char(8) not null; alter table t1 add primary key (a,b,c); update t1 set a=c, b=c; -create table t2 like t1; +create table t2 (c char(8) not null, b char(8) not null, a char(8) not null, primary key(a,b,c)); insert into t2 select * from t1; delete t1,t2 from t2,t1 where t1.a<'B' and t2.b=t1.b; drop table t1,t2; @@ -348,7 +348,7 @@ alter table t1 add b char(8) not null; alter table t1 add a char(8) not null; alter table t1 add primary key (a,b,c); update t1 set a=c, b=c; -create table t2 like t1; +create table t2 (c char(8) not null, b char(8) not null, a char(8) not null, primary key(a,b,c)); insert into t2 select * from t1; delete t1,t2 from t2,t1 where t1.a<'B' and t2.b=t1.b; set @@table_type=@ttype_save; diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index bf6c3db9306..fb2a1ff2b6f 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -286,7 +286,7 @@ alter table t1 add a char(8) not null; alter table t1 add primary key (a,b,c); update t1 set a=c, b=c; -create table t2 like t1; +create table t2 (c char(8) not null, b char(8) not null, a char(8) not null, primary key(a,b,c)); insert into t2 select * from t1; delete t1,t2 from t2,t1 where t1.a<'B' and t2.b=t1.b; @@ -306,7 +306,7 @@ alter table t1 add a char(8) not null; alter table t1 add primary key (a,b,c); update t1 set a=c, b=c; -create table t2 like t1; +create table t2 (c char(8) not null, b char(8) not null, a char(8) not null, primary key(a,b,c)); insert into t2 select * from t1; delete t1,t2 from t2,t1 where t1.a<'B' and t2.b=t1.b; |