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 |