| OLD | NEW |
| 1 # 2011 September 20 | 1 # 2011 September 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 68 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 79 | 79 |
| 80 do_test 2.1 { db_write db } {0 0 0} | 80 do_test 2.1 { db_write db } {0 0 0} |
| 81 do_test 2.2 { | 81 do_test 2.2 { |
| 82 execsql { INSERT INTO t1 VALUES(4, randomblob(600)) } | 82 execsql { INSERT INTO t1 VALUES(4, randomblob(600)) } |
| 83 db_write db | 83 db_write db |
| 84 } {0 4 0} | 84 } {0 4 0} |
| 85 do_test 2.3 { db_write db 1 } {0 4 0} | 85 do_test 2.3 { db_write db 1 } {0 4 0} |
| 86 do_test 2.4 { db_write db 0 } {0 0 0} | 86 do_test 2.4 { db_write db 0 } {0 0 0} |
| 87 do_test 2.5 { db_write db 1 } {0 0 0} | 87 do_test 2.5 { db_write db 1 } {0 0 0} |
| 88 | 88 |
| 89 ifcapable wal { | 89 if {[wal_is_capable]} { |
| 90 do_test 2.6 { | 90 do_test 2.6 { |
| 91 execsql { PRAGMA journal_mode = WAL } | 91 execsql { PRAGMA journal_mode = WAL } |
| 92 db_write db 1 | 92 db_write db 1 |
| 93 } {0 1 0} | 93 } {0 1 0} |
| 94 } | 94 } |
| 95 do_test 2.7 { | 95 do_test 2.7 { |
| 96 execsql { INSERT INTO t1 VALUES(5, randomblob(600)) } | 96 execsql { INSERT INTO t1 VALUES(5, randomblob(600)) } |
| 97 db_write db | 97 db_write db |
| 98 } {0 4 0} | 98 } {0 4 0} |
| 99 do_test 2.8 { db_write db 1 } {0 4 0} | 99 do_test 2.8 { db_write db 1 } {0 4 0} |
| 100 do_test 2.9 { db_write db 0 } {0 0 0} | 100 do_test 2.9 { db_write db 0 } {0 0 0} |
| 101 | 101 |
| 102 finish_test | 102 finish_test |
| OLD | NEW |