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 |