/ Check-in [890816c5]
Login

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: 890816c52d688f01be9a8abd8b4c9375eed4de7e
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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