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

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

Issue 901033002: Import SQLite 3.8.7.4. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Chromium changes to support SQLite 3.8.7.4. Created 5 years, 10 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
OLDNEW
1 # 2009 April 20 1 # 2009 April 20
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 30 matching lines...) Expand all
41 do_test jrnlmode3-1.2 { 41 do_test jrnlmode3-1.2 {
42 db eval { 42 db eval {
43 BEGIN; 43 BEGIN;
44 INSERT INTO t1 VALUES(2); 44 INSERT INTO t1 VALUES(2);
45 ROLLBACK; 45 ROLLBACK;
46 SELECT * FROM t1; 46 SELECT * FROM t1;
47 } 47 }
48 } {1} 48 } {1}
49 49
50 db close 50 db close
51 file delete -force test.db test.db-journal 51 forcedelete test.db test.db-journal
52 sqlite3 db test.db 52 sqlite3 db test.db
53 53
54 do_test jrnlmode3-2.1 { 54 do_test jrnlmode3-2.1 {
55 db eval { 55 db eval {
56 PRAGMA locking_mode=EXCLUSIVE; 56 PRAGMA locking_mode=EXCLUSIVE;
57 PRAGMA journal_mode=OFF; 57 PRAGMA journal_mode=OFF;
58 CREATE TABLE t1(x); 58 CREATE TABLE t1(x);
59 INSERT INTO t1 VALUES(1); 59 INSERT INTO t1 VALUES(1);
60 SELECT * FROM t1; 60 SELECT * FROM t1;
61 } 61 }
(...skipping 16 matching lines...) Expand all
78 foreach fromjmode $all_journal_modes { 78 foreach fromjmode $all_journal_modes {
79 foreach tojmode $all_journal_modes { 79 foreach tojmode $all_journal_modes {
80 80
81 # Skip the no-change cases 81 # Skip the no-change cases
82 if {$fromjmode==$tojmode} continue 82 if {$fromjmode==$tojmode} continue
83 incr cnt 83 incr cnt
84 84
85 # Start with a fresh database connection an empty database file. 85 # Start with a fresh database connection an empty database file.
86 # 86 #
87 db close 87 db close
88 file delete -force test.db test.db-journal 88 forcedelete test.db test.db-journal
89 sqlite3 db test.db 89 sqlite3 db test.db
90 90
91 # Initialize the journal mode. 91 # Initialize the journal mode.
92 # 92 #
93 do_test jrnlmode3-3.$cnt.1-($fromjmode-to-$tojmode) { 93 do_test jrnlmode3-3.$cnt.1-($fromjmode-to-$tojmode) {
94 db eval "PRAGMA journal_mode = $fromjmode;" 94 db eval "PRAGMA journal_mode = $fromjmode;"
95 } $fromjmode 95 } $fromjmode
96 96
97 # Verify that the initial journal mode takes. 97 # Verify that the initial journal mode takes.
98 # 98 #
(...skipping 41 matching lines...) Expand 10 before | Expand all | Expand 10 after
140 } 140 }
141 db eval ROLLBACK 141 db eval ROLLBACK
142 db eval { 142 db eval {
143 SELECT * FROM t1; 143 SELECT * FROM t1;
144 } 144 }
145 } {} 145 } {}
146 } 146 }
147 } 147 }
148 148
149 finish_test 149 finish_test
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698