diff options
Diffstat (limited to 'mysql-test/suite/csv/csv.test')
-rw-r--r-- | mysql-test/suite/csv/csv.test | 18 |
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; |