| 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 |