| Index: third_party/sqlite/sqlite-src-3100200/test/fkey7.test
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/test/fkey7.test b/third_party/sqlite/sqlite-src-3100200/test/fkey7.test
|
| similarity index 76%
|
| copy from third_party/sqlite/sqlite-src-3080704/test/fkey7.test
|
| copy to third_party/sqlite/sqlite-src-3100200/test/fkey7.test
|
| index c2682edbe5fbf3a286693b380046f6592f77e472..6c646a9a7f86931b08ab809670c35d4aa4fe2d64 100644
|
| --- a/third_party/sqlite/sqlite-src-3080704/test/fkey7.test
|
| +++ b/third_party/sqlite/sqlite-src-3100200/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
|
|
|