diff options
Diffstat (limited to 'test/upsert1.test')
-rw-r--r-- | test/upsert1.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/test/upsert1.test b/test/upsert1.test index 6b5be23b7..5250a5d2f 100644 --- a/test/upsert1.test +++ b/test/upsert1.test @@ -233,4 +233,12 @@ do_catchsql_test upsert1-910 { INSERT INTO t1 VALUES(3) ON CONFLICT(x) DO NOTHING; } {1 {cannot UPSERT a view}} +# 2019-12-26 ticket 7c13db5c3bf74001 +reset_db +do_catchsql_test upsert1-1000 { + CREATE TABLE t0(c0 PRIMARY KEY, c1, c2 UNIQUE) WITHOUT ROWID; + INSERT OR FAIL INTO t0(c2) VALUES (0), (NULL) + ON CONFLICT(c2) DO UPDATE SET c1 = c0; +} {1 {NOT NULL constraint failed: t0.c0}} + finish_test |