| OLD | NEW |
| 1 # 2007 April 6 | 1 # 2007 April 6 |
| 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 126 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 137 | 137 |
| 138 do_execsql_test filefmt-2.1.1 { | 138 do_execsql_test filefmt-2.1.1 { |
| 139 PRAGMA page_size = 1024; | 139 PRAGMA page_size = 1024; |
| 140 PRAGMA auto_vacuum = 0; | 140 PRAGMA auto_vacuum = 0; |
| 141 CREATE TABLE t1(a); | 141 CREATE TABLE t1(a); |
| 142 CREATE INDEX i1 ON t1(a); | 142 CREATE INDEX i1 ON t1(a); |
| 143 INSERT INTO t1 VALUES(a_string(3000)); | 143 INSERT INTO t1 VALUES(a_string(3000)); |
| 144 CREATE TABLE t2(a); | 144 CREATE TABLE t2(a); |
| 145 INSERT INTO t2 VALUES(1); | 145 INSERT INTO t2 VALUES(1); |
| 146 } {} | 146 } {} |
| 147 do_test filefmt-2.1.2 { | 147 if {![nonzero_reserved_bytes]} { |
| 148 hexio_read test.db 28 4 | 148 do_test filefmt-2.1.2 { |
| 149 } {00000009} | 149 hexio_read test.db 28 4 |
| 150 } {00000009} |
| 151 } |
| 150 | 152 |
| 151 do_test filefmt-2.1.3 { | 153 do_test filefmt-2.1.3 { |
| 152 sql36231 { INSERT INTO t1 VALUES(a_string(3000)) } | 154 sql36231 { INSERT INTO t1 VALUES(a_string(3000)) } |
| 153 } {} | 155 } {} |
| 154 | 156 |
| 155 do_execsql_test filefmt-2.1.4 { INSERT INTO t2 VALUES(2) } {} | 157 do_execsql_test filefmt-2.1.4 { INSERT INTO t2 VALUES(2) } {} |
| 156 integrity_check filefmt-2.1.5 | 158 integrity_check filefmt-2.1.5 |
| 157 do_test filefmt-2.1.6 { hexio_read test.db 28 4 } {00000010} | 159 do_test filefmt-2.1.6 { hexio_read test.db 28 4 } {00000010} |
| 158 | 160 |
| 159 db close | 161 db close |
| 160 forcedelete test.db | 162 forcedelete test.db |
| 161 sqlite3 db test.db | 163 sqlite3 db test.db |
| 162 db func a_string a_string | 164 db func a_string a_string |
| 163 | 165 |
| 164 do_execsql_test filefmt-2.2.1 { | 166 do_execsql_test filefmt-2.2.1 { |
| 165 PRAGMA page_size = 1024; | 167 PRAGMA page_size = 1024; |
| 166 PRAGMA auto_vacuum = 0; | 168 PRAGMA auto_vacuum = 0; |
| 167 CREATE TABLE t1(a); | 169 CREATE TABLE t1(a); |
| 168 CREATE INDEX i1 ON t1(a); | 170 CREATE INDEX i1 ON t1(a); |
| 169 INSERT INTO t1 VALUES(a_string(3000)); | 171 INSERT INTO t1 VALUES(a_string(3000)); |
| 170 CREATE TABLE t2(a); | 172 CREATE TABLE t2(a); |
| 171 INSERT INTO t2 VALUES(1); | 173 INSERT INTO t2 VALUES(1); |
| 172 } {} | 174 } {} |
| 173 do_test filefmt-2.2.2 { | 175 if {![nonzero_reserved_bytes]} { |
| 174 hexio_read test.db 28 4 | 176 do_test filefmt-2.2.2 { |
| 175 } {00000009} | 177 hexio_read test.db 28 4 |
| 178 } {00000009} |
| 179 } |
| 176 | 180 |
| 177 do_test filefmt-2.2.3 { | 181 do_test filefmt-2.2.3 { |
| 178 sql36231 { INSERT INTO t1 VALUES(a_string(3000)) } | 182 sql36231 { INSERT INTO t1 VALUES(a_string(3000)) } |
| 179 } {} | 183 } {} |
| 180 | 184 |
| 181 do_execsql_test filefmt-2.2.4 { | 185 do_execsql_test filefmt-2.2.4 { |
| 182 PRAGMA integrity_check; | 186 PRAGMA integrity_check; |
| 183 BEGIN; | 187 BEGIN; |
| 184 INSERT INTO t2 VALUES(2); | 188 INSERT INTO t2 VALUES(2); |
| 185 SAVEPOINT a; | 189 SAVEPOINT a; |
| (...skipping 55 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 241 db backup bak.db | 245 db backup bak.db |
| 242 } {} | 246 } {} |
| 243 | 247 |
| 244 do_test filefmt-4.4 { | 248 do_test filefmt-4.4 { |
| 245 sqlite3 db2 bak.db | 249 sqlite3 db2 bak.db |
| 246 db2 eval { PRAGMA integrity_check } | 250 db2 eval { PRAGMA integrity_check } |
| 247 } {ok} | 251 } {ok} |
| 248 db2 close | 252 db2 close |
| 249 | 253 |
| 250 finish_test | 254 finish_test |
| OLD | NEW |