1 files changed, 6 insertions, 6 deletions

diff --git a/mysql-test/suite/vcol/inc/vcol_ins_upd.inc b/mysql-test/suite/vcol/inc/vcol_ins_upd.inc
index a7a43aae529..945884b3cd5 100644
--- a/mysql-test/suite/vcol/inc/vcol_ins_upd.inc
+++ b/mysql-test/suite/vcol/inc/vcol_ins_upd.inc
@@ -47,7 +47,7 @@ delete from t1;
 select * from t1;
 
 --echo # INSERT INTO tbl_name VALUES... a non-NULL value is specified against vcols
-insert into t1 values (1,2,3);
+insert ignore into t1 values (1,2,3);
 select * from t1;
 delete from t1;
 select * from t1;
@@ -73,7 +73,7 @@ select * from t1;
 
 --echo # INSERT INTO tbl_name (<normal+vcols>) VALUES... a non-NULL value is specified 
 --echo # against vcols
-insert into t1 (a,b) values (1,3), (2,4);
+insert ignore into t1 (a,b) values (1,3), (2,4);
 select * from t1;
 delete from t1;
 select * from t1;
@@ -101,7 +101,7 @@ select a,b,c from t1;
 --echo # CREATE new_table ... LIKE old_table
 --echo # INSERT INTO new_table SELECT * from old_table
 create table t2 like t1;
-insert into t2 select * from t1;
+insert ignore into t2 select * from t1;
 select * from t1;
 drop table t2;
 
@@ -110,7 +110,7 @@ drop table t2;
 insert into t1 values (1,default,default);
 select * from t1;
 create table t2 like t1;
-insert into t2 (a,b) select a,b from t1;
+insert ignore into t2 (a,b) select a,b from t1;
 select * from t2;
 drop table t2;
 drop table t1;
@@ -131,7 +131,7 @@ select * from t1;
 --echo # UPDATE tbl_name SET vcol=expr WHERE non-vcol=expr
 insert into t1 (a) values (1), (2);
 select * from t1;
-update t1 set c=3 where a=2;
+update ignore t1 set c=3 where a=2;
 select * from t1;
 delete from t1;
 select * from t1;
@@ -147,7 +147,7 @@ select * from t1;
 --echo # UPDATE tbl_name SET vcol=expr WHERE vcol=expr
 insert into t1 (a) values (1), (2);
 select * from t1;
-update t1 set c=3 where b=-2;
+update ignore t1 set c=3 where b=-2;
 select * from t1;
 delete from t1;
 select * from t1;