1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/suite/csv/csv.test b/mysql-test/suite/csv/csv.test
index 413ffdc5cfa..3da9aca7b16 100644
--- a/mysql-test/suite/csv/csv.test
+++ b/mysql-test/suite/csv/csv.test
@@ -1738,27 +1738,27 @@ drop table t1;
 # Bug #31473: does not work with NULL value in datetime field
 #
 create table t1(a datetime not null) engine=csv;
-insert into t1 values();
+insert ignore into t1 values();
 select * from t1;
 drop table t1;
 create table t1(a set('foo','bar') not null) engine=csv;
-insert into t1 values();
+insert ignore into t1 values();
 select * from t1;
 drop table t1;
 create table t1(a varchar(32) not null) engine=csv;
-insert into t1 values();
+insert ignore into t1 values();
 select * from t1;
 drop table t1;
 create table t1(a int not null) engine=csv;
-insert into t1 values();
+insert ignore into t1 values();
 select * from t1;
 drop table t1;
 create table t1(a blob not null) engine=csv;
-insert into t1 values();
+insert ignore into t1 values();
 select * from t1;
 drop table t1;
 create table t1(a bit(1) not null) engine=csv;
-insert into t1 values();
+insert ignore into t1 values();
 select BIN(a) from t1;
 drop table t1;
 # We prevent creation of table with nullable ENUM
@@ -1815,9 +1815,9 @@ drop table t1;
 CREATE TABLE t1 (e enum('foo','bar') NOT NULL) ENGINE = CSV;
 INSERT INTO t1 VALUES();
 INSERT INTO t1 VALUES(default);
-INSERT INTO t1 VALUES(0);
-INSERT INTO t1 VALUES(3);
-INSERT INTO t1 VALUES(-1);
+INSERT IGNORE INTO t1 VALUES(0);
+INSERT IGNORE INTO t1 VALUES(3);
+INSERT IGNORE INTO t1 VALUES(-1);
 SELECT * FROM t1;
 DROP TABLE t1;