aboutsummaryrefslogtreecommitdiff
path: root/test/upsert1.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/upsert1.test')
-rw-r--r--test/upsert1.test8
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