| OLD | NEW |
| 1 # 2007 March 19 | 1 # 2007 March 19 |
| 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 178 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 189 do_test vacuum3-3.$I.2 { | 189 do_test vacuum3-3.$I.2 { |
| 190 signature | 190 signature |
| 191 } $::sig | 191 } $::sig |
| 192 integrity_check vacuum3-3.$I.3 | 192 integrity_check vacuum3-3.$I.3 |
| 193 | 193 |
| 194 incr I | 194 incr I |
| 195 } | 195 } |
| 196 | 196 |
| 197 do_test vacuum3-4.1 { | 197 do_test vacuum3-4.1 { |
| 198 db close | 198 db close |
| 199 file delete test.db | 199 delete_file test.db |
| 200 sqlite3 db test.db | 200 sqlite3 db test.db |
| 201 execsql { | 201 execsql { |
| 202 PRAGMA page_size=1024; | 202 PRAGMA page_size=1024; |
| 203 CREATE TABLE abc(a, b, c); | 203 CREATE TABLE abc(a, b, c); |
| 204 INSERT INTO abc VALUES(1, 2, 3); | 204 INSERT INTO abc VALUES(1, 2, 3); |
| 205 INSERT INTO abc VALUES(4, 5, 6); | 205 INSERT INTO abc VALUES(4, 5, 6); |
| 206 } | 206 } |
| 207 execsql { SELECT * FROM abc } | 207 execsql { SELECT * FROM abc } |
| 208 } {1 2 3 4 5 6} | 208 } {1 2 3 4 5 6} |
| 209 do_test vacuum3-4.2 { | 209 do_test vacuum3-4.2 { |
| (...skipping 121 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 331 CREATE TABLE t1(a, b, c); | 331 CREATE TABLE t1(a, b, c); |
| 332 INSERT INTO t1 VALUES(1, 2, 3); | 332 INSERT INTO t1 VALUES(1, 2, 3); |
| 333 CREATE TABLE t2(x,y,z); | 333 CREATE TABLE t2(x,y,z); |
| 334 INSERT INTO t2 SELECT * FROM t1; | 334 INSERT INTO t2 SELECT * FROM t1; |
| 335 } -sqlbody { | 335 } -sqlbody { |
| 336 VACUUM; | 336 VACUUM; |
| 337 } | 337 } |
| 338 } | 338 } |
| 339 | 339 |
| 340 finish_test | 340 finish_test |
| OLD | NEW |