Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(258)

Side by Side Diff: third_party/sqlite/src/test/e_fkey.test

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
« no previous file with comments | « third_party/sqlite/src/test/e_expr.test ('k') | third_party/sqlite/src/test/e_select.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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
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
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
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/e_expr.test ('k') | third_party/sqlite/src/test/e_select.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698