OLD | NEW |
1 # 2009 October 7 | 1 # 2009 October 7 |
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 34 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
45 INSERT INTO c VALUES('hello'); | 45 INSERT INTO c VALUES('hello'); |
46 UPDATE p SET i = 'world'; | 46 UPDATE p SET i = 'world'; |
47 SELECT * FROM c; | 47 SELECT * FROM c; |
48 } | 48 } |
49 } {world} | 49 } {world} |
50 } | 50 } |
51 | 51 |
52 #------------------------------------------------------------------------- | 52 #------------------------------------------------------------------------- |
53 # Test the effects of defining OMIT_TRIGGER but not OMIT_FOREIGN_KEY. | 53 # Test the effects of defining OMIT_TRIGGER but not OMIT_FOREIGN_KEY. |
54 # | 54 # |
55 # EVIDENCE-OF: R-44697-61543 If SQLITE_OMIT_TRIGGER is defined but | 55 # EVIDENCE-OF: R-10109-20452 If SQLITE_OMIT_TRIGGER is defined but |
56 # SQLITE_OMIT_FOREIGN_KEY is not, then SQLite behaves as it did prior to | 56 # SQLITE_OMIT_FOREIGN_KEY is not, then SQLite behaves as it did prior to |
57 # version 3.6.19 - foreign key definitions are parsed and may be queried | 57 # version 3.6.19 (2009-10-14) - foreign key definitions are parsed and |
58 # using PRAGMA foreign_key_list, but foreign key constraints are not | 58 # may be queried using PRAGMA foreign_key_list, but foreign key |
59 # enforced. | 59 # constraints are not enforced. |
60 # | 60 # |
61 # Specifically, test that "PRAGMA foreign_keys" is a no-op in this case. | 61 # Specifically, test that "PRAGMA foreign_keys" is a no-op in this case. |
62 # When using the pragma to query the current setting, 0 rows are returned. | 62 # When using the pragma to query the current setting, 0 rows are returned. |
63 # | 63 # |
64 # EVIDENCE-OF: R-22567-44039 The PRAGMA foreign_keys command is a no-op | 64 # EVIDENCE-OF: R-22567-44039 The PRAGMA foreign_keys command is a no-op |
65 # in this configuration. | 65 # in this configuration. |
66 # | 66 # |
67 # EVIDENCE-OF: R-41784-13339 Tip: If the command "PRAGMA foreign_keys" | 67 # EVIDENCE-OF: R-41784-13339 Tip: If the command "PRAGMA foreign_keys" |
68 # returns no data instead of a single row containing "0" or "1", then | 68 # returns no data instead of a single row containing "0" or "1", then |
69 # the version of SQLite you are using does not support foreign keys | 69 # the version of SQLite you are using does not support foreign keys |
(...skipping 2944 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
3014 } {1} | 3014 } {1} |
3015 do_test e_fkey-64.$recursive_triggers_setting.3 { | 3015 do_test e_fkey-64.$recursive_triggers_setting.3 { |
3016 execsql { | 3016 execsql { |
3017 DELETE FROM t1 WHERE a = 1; | 3017 DELETE FROM t1 WHERE a = 1; |
3018 SELECT count(*) FROM t1; | 3018 SELECT count(*) FROM t1; |
3019 } | 3019 } |
3020 } {0} | 3020 } {0} |
3021 } | 3021 } |
3022 | 3022 |
3023 finish_test | 3023 finish_test |
OLD | NEW |