OLD | NEW |
1 # 2011 Feb 04 | 1 # 2011 Feb 04 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 24 matching lines...) Expand all Loading... |
35 INSERT INTO t2 VALUES(1,3); | 35 INSERT INTO t2 VALUES(1,3); |
36 } | 36 } |
37 } {} | 37 } {} |
38 | 38 |
39 do_test fkey4-1.2 { | 39 do_test fkey4-1.2 { |
40 set ::DB [sqlite3_connection_pointer db] | 40 set ::DB [sqlite3_connection_pointer db] |
41 set ::SQL {INSERT INTO t2 VALUES(2,4)} | 41 set ::SQL {INSERT INTO t2 VALUES(2,4)} |
42 set ::STMT1 [sqlite3_prepare_v2 $::DB $::SQL -1 TAIL] | 42 set ::STMT1 [sqlite3_prepare_v2 $::DB $::SQL -1 TAIL] |
43 sqlite3_step $::STMT1 | 43 sqlite3_step $::STMT1 |
44 } {SQLITE_CONSTRAINT} | 44 } {SQLITE_CONSTRAINT} |
| 45 verify_ex_errcode fkey4-1.2b SQLITE_CONSTRAINT_FOREIGNKEY |
45 do_test fkey4-1.3 { | 46 do_test fkey4-1.3 { |
46 set ::STMT2 [sqlite3_prepare_v2 $::DB $::SQL -1 TAIL] | 47 set ::STMT2 [sqlite3_prepare_v2 $::DB $::SQL -1 TAIL] |
47 sqlite3_step $::STMT2 | 48 sqlite3_step $::STMT2 |
48 } {SQLITE_CONSTRAINT} | 49 } {SQLITE_CONSTRAINT} |
| 50 verify_ex_errcode fkey4-1.3b SQLITE_CONSTRAINT_FOREIGNKEY |
49 do_test fkey4-1.4 { | 51 do_test fkey4-1.4 { |
50 db eval {SELECT * FROM t2} | 52 db eval {SELECT * FROM t2} |
51 } {1 3} | 53 } {1 3} |
52 sqlite3_finalize $::STMT1 | 54 sqlite3_finalize $::STMT1 |
53 sqlite3_finalize $::STMT2 | 55 sqlite3_finalize $::STMT2 |
54 | 56 |
55 finish_test | 57 finish_test |
OLD | NEW |