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 |