diff options
| author | unknown <pcrews@pcrews-mac-local.local> | 2008-02-14 08:17:47 -0500 |
|---|---|---|
| committer | unknown <pcrews@pcrews-mac-local.local> | 2008-02-14 08:17:47 -0500 |
| commit | e79caaad103be07944bfcb8fdb89ca028122ca3a (patch) | |
| tree | 6a25e43b09ce0f2ced22ac09b4ac105626bf642a /mysql-test/r/csv_not_null.result | |
| parent | 6262c056fa8cff69073d3f9f58692d64ec4d2b60 (diff) | |
| download | mariadb-git-e79caaad103be07944bfcb8fdb89ca028122ca3a.tar.gz | |
Bug#34468 - csv_not_null fails
Altered test to expect error on UPDATE SET <not_null_col> = NULL instead
of expecting warning and re-recorded .result file.
mysql-test/r/csv_not_null.result:
Bug#34468 - csv_not_null fails
Altered test to expect error on UPDATE SET <not_null_col> = NULL instead
of expecting warning and re-recorded .result file. New results file passes
mysql-test/t/csv_not_null.test:
Bug#34468 - csv_not_null fails
Altered test to expect error on UPDATE SET <not_null_col> = NULL instead
of expecting warning and re-recorded .result file. Also cleaned up comments
Diffstat (limited to 'mysql-test/r/csv_not_null.result')
| -rw-r--r-- | mysql-test/r/csv_not_null.result | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/mysql-test/r/csv_not_null.result b/mysql-test/r/csv_not_null.result index ccd88631ce6..77026b8f056 100644 --- a/mysql-test/r/csv_not_null.result +++ b/mysql-test/r/csv_not_null.result @@ -38,9 +38,6 @@ DROP TABLE t1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a int NOT NULL, b char(10) NOT NULL) ENGINE = CSV; INSERT INTO t1 VALUES(); -Warnings: -Warning 1364 Field 'a' doesn't have a default value -Warning 1364 Field 'b' doesn't have a default value SELECT * FROM t1; a b 0 @@ -49,9 +46,8 @@ SELECT * FROM t1; a b 0 new_value UPDATE t1 set b = NULL where b = 'new_value'; -Warnings: -Warning 1048 Column 'b' cannot be null +ERROR 23000: Column 'b' cannot be null SELECT * FROM t1; a b -0 +0 new_value DROP TABLE t1; |