| OLD | NEW |
| 1 # 2010 June 16 | 1 # 2010 June 16 |
| 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 186 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 197 db2 close | 197 db2 close |
| 198 } {} | 198 } {} |
| 199 db close | 199 db close |
| 200 | 200 |
| 201 #------------------------------------------------------------------------- | 201 #------------------------------------------------------------------------- |
| 202 # Test that it is possible to switch from journal_mode=truncate to | 202 # Test that it is possible to switch from journal_mode=truncate to |
| 203 # journal_mode=WAL on a SAFE_DELETE file-system. SQLite should close and | 203 # journal_mode=WAL on a SAFE_DELETE file-system. SQLite should close and |
| 204 # delete the journal file when committing the transaction that switches | 204 # delete the journal file when committing the transaction that switches |
| 205 # the system to WAL mode. | 205 # the system to WAL mode. |
| 206 # | 206 # |
| 207 ifcapable wal { | 207 if {[wal_is_capable]} { |
| 208 do_test journal2-2.1 { | 208 do_test journal2-2.1 { |
| 209 faultsim_delete_and_reopen | 209 faultsim_delete_and_reopen |
| 210 set ::oplog [list] | 210 set ::oplog [list] |
| 211 execsql { PRAGMA journal_mode = persist } | 211 execsql { PRAGMA journal_mode = persist } |
| 212 set ::oplog | 212 set ::oplog |
| 213 } {} | 213 } {} |
| 214 do_test journal2-2.2 { | 214 do_test journal2-2.2 { |
| 215 execsql { | 215 execsql { |
| 216 CREATE TABLE t1(x); | 216 CREATE TABLE t1(x); |
| 217 INSERT INTO t1 VALUES(3.14159); | 217 INSERT INTO t1 VALUES(3.14159); |
| 218 } | 218 } |
| 219 set ::oplog | 219 set ::oplog |
| 220 } {xOpen test.db-journal} | 220 } {xOpen test.db-journal} |
| 221 do_test journal2-2.3 { | 221 do_test journal2-2.3 { |
| 222 expr {[file size test.db-journal] > 512} | 222 expr {[file size test.db-journal] > 512} |
| 223 } {1} | 223 } {1} |
| 224 do_test journal2-2.4 { | 224 do_test journal2-2.4 { |
| 225 set ::oplog [list] | 225 set ::oplog [list] |
| 226 execsql { PRAGMA journal_mode = WAL } | 226 execsql { PRAGMA journal_mode = WAL } |
| 227 set ::oplog | 227 set ::oplog |
| 228 } {xClose test.db-journal xDelete test.db-journal} | 228 } {xClose test.db-journal xDelete test.db-journal} |
| 229 db close | 229 db close |
| 230 } | 230 } |
| 231 | 231 |
| 232 tvfs delete | 232 tvfs delete |
| 233 finish_test | 233 finish_test |
| OLD | NEW |