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