| OLD | NEW |
| 1 # 2011 May 09 | 1 # 2011 May 09 |
| 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 194 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 205 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 205 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 206 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 206 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 207 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 207 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 208 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 208 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 209 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 209 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 210 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 210 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 211 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 211 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 212 INSERT INTO t2 SELECT x||y, y||x FROM t2; | 212 INSERT INTO t2 SELECT x||y, y||x FROM t2; |
| 213 } | 213 } |
| 214 file size test.db-wal | 214 file size test.db-wal |
| 215 } {147800} | 215 } [expr {[nonzero_reserved_bytes]?148848:147800}] |
| 216 do_test 1.4.4.2 { | 216 do_test 1.4.4.2 { |
| 217 csql1 { SELECT * FROM t1 } | 217 csql1 { SELECT * FROM t1 } |
| 218 } {0 {a b c d e f g h i j k l 1 2 3 4 5 6}} | 218 } {0 {a b c d e f g h i j k l 1 2 3 4 5 6}} |
| 219 do_test 1.4.4.3 { | 219 do_test 1.4.4.3 { |
| 220 csql2 COMMIT | 220 csql2 COMMIT |
| 221 csql1 { SELECT count(*) FROM t2 } | 221 csql1 { SELECT count(*) FROM t2 } |
| 222 } {0 512} | 222 } {0 512} |
| 223 do_test 1.4.5 { | 223 do_test 1.4.5 { |
| 224 code2 { db2 close } | 224 code2 { db2 close } |
| 225 code1 { db close } | 225 code1 { db close } |
| (...skipping 60 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 286 set res [csql1 { PRAGMA wal_checkpoint }] | 286 set res [csql1 { PRAGMA wal_checkpoint }] |
| 287 do_test 2.1.4 { set res } {0 {0 2 2}} | 287 do_test 2.1.4 { set res } {0 {0 2 2}} |
| 288 | 288 |
| 289 do_test 2.1.5 { | 289 do_test 2.1.5 { |
| 290 code1 { db close } | 290 code1 { db close } |
| 291 code1 { tv delete } | 291 code1 { tv delete } |
| 292 } {} | 292 } {} |
| 293 } | 293 } |
| 294 | 294 |
| 295 finish_test | 295 finish_test |
| OLD | NEW |