Index: third_party/sqlite/src/test/fkey7.test |
diff --git a/third_party/sqlite/src/test/fkey7.test b/third_party/sqlite/src/test/fkey7.test |
index c2682edbe5fbf3a286693b380046f6592f77e472..6c646a9a7f86931b08ab809670c35d4aa4fe2d64 100644 |
--- a/third_party/sqlite/src/test/fkey7.test |
+++ b/third_party/sqlite/src/test/fkey7.test |
@@ -50,5 +50,22 @@ do_tblsread_test 1.3 { UPDATE par SET a=? WHERE b=? } {c1 c2 par} |
do_tblsread_test 1.4 { UPDATE par SET c=? WHERE b=? } {c3 par} |
do_tblsread_test 1.5 { UPDATE par SET a=?,b=?,c=? WHERE b=? } {c1 c2 c3 par s1} |
+ifcapable incrblob { |
+ do_execsql_test 2.0 { |
+ CREATE TABLE pX(x PRIMARY KEY); |
+ CREATE TABLE cX(a INTEGER PRIMARY KEY, b REFERENCES pX); |
+ } |
+ |
+ do_catchsql_test 2.1 { |
+ INSERT INTO cX VALUES(11, zeroblob(40)); |
+ } {1 {FOREIGN KEY constraint failed}} |
+ |
+ do_test 2.2 { |
+ set stmt [sqlite3_prepare_v2 db "INSERT INTO cX VALUES(11, ?)" -1] |
+ sqlite3_bind_zeroblob $stmt 1 45 |
+ sqlite3_step $stmt |
+ sqlite3_finalize $stmt |
+ } {SQLITE_CONSTRAINT} |
+} |
finish_test |