Import SQLite 3.8.7.4.

third_party/sqlite/src/test/e_vacuum.test

 # 2010 September 24
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 47 matching lines @@
     if {[info exists prevpageno] && $prevpageno != $pageno-1} {
       incr nFrag
     }
     set prevpageno $pageno
   }
   execsql { DROP TABLE temp.stat }
   set nFrag
 }
 
 
-# EVIDENCE-OF: R-63707-33375 -- syntax diagram vacuum-stmt
+# -- syntax diagram vacuum-stmt
 #
 do_execsql_test e_vacuum-0.1 { VACUUM } {}
 
 # EVIDENCE-OF: R-51469-36013 Unless SQLite is running in
 # "auto_vacuum=FULL" mode, when a large amount of data is deleted from
 # the database file it leaves behind empty space, or "free" database
 # pages.
 #
 # EVIDENCE-OF: R-60541-63059 Running VACUUM to rebuild the database
 # reclaims this space and reduces the size of the database file.
@@ skipping 36 matching lines @@
 #
 # EVIDENCE-OF: R-05791-54928 Running VACUUM ensures that each table and
 # index is largely stored contiguously within the database file.
 #
 #   e_vacuum-1.2.1 - Perform many INSERT, UPDATE and DELETE ops on table t1.
 #   e_vacuum-1.2.2 - Verify that t1 and its indexes are now quite fragmented.
 #   e_vacuum-1.2.3 - Run VACUUM.
 #   e_vacuum-1.2.4 - Verify that t1 and its indexes are now much 
 #                    less fragmented.
 #
-ifcapable vtab {
+ifcapable vtab&&compound {
   create_db 
   register_dbstat_vtab db
   do_execsql_test e_vacuum-1.2.1 {
     DELETE FROM t1 WHERE a%2;
     INSERT INTO t1 SELECT b, a FROM t2 WHERE a%2;
     UPDATE t1 SET b=randomblob(600) WHERE (a%2)==0;
   } {}
   
   do_test e_vacuum-1.2.2.1 { expr [fragment_count t1]>100 } 1
   do_test e_vacuum-1.2.2.2 { expr [fragment_count sqlite_autoindex_t1_1]>100 } 1
@@ skipping 158 matching lines @@
   create_db { PRAGMA auto_vacuum = INCREMENTAL }
   execsql {
     DELETE FROM t1;
     DELETE FROM t2;
     PRAGMA incremental_vacuum;
   }
   expr {[file size test.db] / 1024}
 } {8}
 
 finish_test