diff options
Diffstat (limited to 'mysql-test/suite/csv/csv_not_null.test')
| -rw-r--r-- | mysql-test/suite/csv/csv_not_null.test | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/mysql-test/suite/csv/csv_not_null.test b/mysql-test/suite/csv/csv_not_null.test index bebea53b2f7..2ddf151b05e 100644 --- a/mysql-test/suite/csv/csv_not_null.test +++ b/mysql-test/suite/csv/csv_not_null.test @@ -12,6 +12,8 @@ --source include/have_csv.inc +call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired"); + ############################################################################# # Testcase csv_not_null.1: CREATE TABLE for CSV Engine requires explicit # NOT NULL for each column @@ -50,17 +52,20 @@ d VARCHAR(20) NOT NULL, e enum('foo','bar') NOT NULL,f DATE NOT NULL) ENGINE = CSV; -- echo # === should result in default for each datatype === -- disable_warnings -INSERT INTO t1 VALUES(); +INSERT IGNORE INTO t1 VALUES(); -- enable_warnings +--error ER_CRASHED_ON_USAGE SELECT * FROM t1; -- disable_warnings # Bug#33717 - INSERT...(default) fails for enum. -INSERT INTO t1 VALUES(default,default,default,default,default,default); +INSERT IGNORE INTO t1 VALUES(default,default,default,default,default,default); -- enable_warnings +--error ER_CRASHED_ON_USAGE SELECT * FROM t1; INSERT INTO t1 VALUES(0,'abc','def','ghi','bar','1999-12-31'); +--error ER_CRASHED_ON_USAGE SELECT * FROM t1; -- echo # === insert failures === --error ER_BAD_NULL_ERROR @@ -84,14 +89,14 @@ DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a int NOT NULL, b char(10) NOT NULL) ENGINE = CSV; --disable_warnings -INSERT INTO t1 VALUES(); +INSERT IGNORE INTO t1 VALUES(); --enable_warnings SELECT * FROM t1; --disable_warnings UPDATE t1 set b = 'new_value' where a = 0; --enable_warnings SELECT * FROM t1; -UPDATE t1 set b = NULL where b = 'new_value'; +UPDATE IGNORE t1 set b = NULL where b = 'new_value'; SELECT * FROM t1; DROP TABLE t1; |