Fix for bug #1980 tests

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;