OLD | NEW |
1 # 2010 November 1 | 1 # 2010 November 1 |
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 69 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
80 INSERT INTO t2 VALUES('c', 'd'); | 80 INSERT INTO t2 VALUES('c', 'd'); |
81 } | 81 } |
82 do_execsql_test 2.1.2 { | 82 do_execsql_test 2.1.2 { |
83 PRAGMA locking_mode = exclusive; | 83 PRAGMA locking_mode = exclusive; |
84 PRAGMA journal_mode = WAL; | 84 PRAGMA journal_mode = WAL; |
85 INSERT INTO t2 VALUES('e', 'f'); | 85 INSERT INTO t2 VALUES('e', 'f'); |
86 INSERT INTO t2 VALUES('g', 'h'); | 86 INSERT INTO t2 VALUES('g', 'h'); |
87 } {exclusive wal} | 87 } {exclusive wal} |
88 | 88 |
89 do_test 2.1.3 { | 89 do_test 2.1.3 { |
90 file copy -force test.db test2.db | 90 forcecopy test.db test2.db |
91 file copy -force test.db-wal test2.db-wal | 91 forcecopy test.db-wal test2.db-wal |
92 sqlite3 db2 test2.db | 92 sqlite3 db2 test2.db |
93 catchsql { SELECT * FROM t2 } db2 | 93 catchsql { SELECT * FROM t2 } db2 |
94 } {1 {unable to open database file}} | 94 } {1 {unable to open database file}} |
95 do_test 2.1.4 { | 95 do_test 2.1.4 { |
96 catchsql { PRAGMA journal_mode = delete } db2 | 96 catchsql { PRAGMA journal_mode = delete } db2 |
97 } {1 {unable to open database file}} | 97 } {1 {unable to open database file}} |
98 do_test 2.1.5 { | 98 do_test 2.1.5 { |
99 execsql { | 99 execsql { |
100 PRAGMA locking_mode = exclusive; | 100 PRAGMA locking_mode = exclusive; |
101 PRAGMA journal_mode = delete; | 101 PRAGMA journal_mode = delete; |
102 SELECT * FROM t2; | 102 SELECT * FROM t2; |
103 } db2 | 103 } db2 |
104 } {exclusive delete a b c d e f g h} | 104 } {exclusive delete a b c d e f g h} |
105 | 105 |
106 do_test 2.2.1 { | 106 do_test 2.2.1 { |
107 file copy -force test.db test2.db | 107 forcecopy test.db test2.db |
108 file copy -force test.db-wal test2.db-wal | 108 forcecopy test.db-wal test2.db-wal |
109 sqlite3 db3 test2.db -vfs tvfsshm | 109 sqlite3 db3 test2.db -vfs tvfsshm |
110 sqlite3 db2 test2.db | 110 sqlite3 db2 test2.db |
111 execsql { SELECT * FROM t2 } db3 | 111 execsql { SELECT * FROM t2 } db3 |
112 } {a b c d e f g h} | 112 } {a b c d e f g h} |
113 | 113 |
114 do_test 2.2.2 { | 114 do_test 2.2.2 { |
115 execsql { PRAGMA locking_mode = exclusive } db2 | 115 execsql { PRAGMA locking_mode = exclusive } db2 |
116 catchsql { PRAGMA journal_mode = delete } db2 | 116 catchsql { PRAGMA journal_mode = delete } db2 |
117 } {1 {database is locked}} | 117 } {1 {database is locked}} |
118 | 118 |
(...skipping 56 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
175 sqlite3 db2 test.db -vfs tvfsshm | 175 sqlite3 db2 test.db -vfs tvfsshm |
176 catchsql { SELECT * FROM t1 } db2 | 176 catchsql { SELECT * FROM t1 } db2 |
177 } {1 {database is locked}} | 177 } {1 {database is locked}} |
178 db close | 178 db close |
179 db2 close | 179 db2 close |
180 | 180 |
181 tvfs delete | 181 tvfs delete |
182 tvfsshm delete | 182 tvfsshm delete |
183 | 183 |
184 finish_test | 184 finish_test |
OLD | NEW |