Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Updates to e_vacuum.test so that it works when SQLITE_DEFAULT_AUTOVACUUM=1 is set. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
890816c52d688f01be9a8abd8b4c9375 |
| User & Date: | drh 2010-09-28 15:25:21 |
Context
|
2010-09-28
| ||
| 15:55 | Disallow statements of the form "CREATE TEMP TABLE main.t1 ...". (check-in: dd1b34ba user: dan tags: trunk) | |
| 15:25 | Updates to e_vacuum.test so that it works when SQLITE_DEFAULT_AUTOVACUUM=1 is set. (check-in: 890816c5 user: drh tags: trunk) | |
| 14:26 | Fix several harmless compiler warnings. (check-in: 7be03ecc user: drh tags: trunk) | |
Changes
Changes to test/e_vacuum.test.
185 185 execsql VACUUM 186 186 execsql { PRAGMA page_size ; PRAGMA auto_vacuum } 187 187 } {2048 1} 188 188 189 189 # EVIDENCE-OF: R-38001-03952 VACUUM only works on the main database. It 190 190 # is not possible to VACUUM an attached database file. 191 191 forcedelete test.db2 192 -create_db 192 +create_db { PRAGMA auto_vacuum = NONE } 193 193 do_execsql_test e_vacuum-2.1.1 { 194 194 ATTACH 'test.db2' AS aux; 195 195 PRAGMA aux.page_size = 1024; 196 196 CREATE TABLE aux.t3 AS SELECT * FROM t1; 197 197 DELETE FROM t3; 198 198 } {} 199 -do_test e_vacuum-2.1.2 { expr { ([file size test.db2] / 1024)>50 } } 1 199 +set original_size [file size test.db2] 200 200 201 201 # Try everything we can think of to get the aux database vacuumed: 202 202 do_execsql_test e_vacuum-2.1.3 { VACUUM } {} 203 203 do_execsql_test e_vacuum-2.1.4 { VACUUM aux } {} 204 204 do_execsql_test e_vacuum-2.1.5 { VACUUM 'test.db2' } {} 205 205 206 206 # Despite our efforts, space in the aux database has not been reclaimed: 207 -do_test e_vacuum-2.1.6 { expr { ([file size test.db2] / 1024)>50 } } 1 207 +do_test e_vacuum-2.1.6 { expr {[file size test.db2]==$::original_size} } 1 208 208 209 209 # EVIDENCE-OF: R-17495-17419 The VACUUM command may change the ROWIDs of 210 210 # entries in any tables that do not have an explicit INTEGER PRIMARY 211 211 # KEY. 212 212 # 213 213 # Tests e_vacuum-3.1.1 - 3.1.2 demonstrate that rowids can change when 214 214 # a database is VACUUMed. Tests e_vacuum-3.1.3 - 3.1.4 show that adding