Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch

third_party/sqlite/src/test/vacuum.test

 # 2001 September 15
 #
 # 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 190 matching lines @@
 integrity_check vacuum-2.11
 db3 close
  
 
 # Ticket #427.  Make sure VACUUM works when the EMPTY_RESULT_CALLBACKS
 # pragma is turned on.
 #
 do_test vacuum-3.1 {
   db close
   db2 close
-  file delete test.db
+  delete_file test.db
   sqlite3 db test.db
   execsql {
     PRAGMA empty_result_callbacks=on;
     VACUUM;
   }
 } {}
 
 # Ticket #464.  Make sure VACUUM works with the sqlite3_prepare() API.
 #
 do_test vacuum-4.1 {
   db close
   sqlite3 db test.db; set DB [sqlite3_connection_pointer db]
   set VM [sqlite3_prepare $DB {VACUUM} -1 TAIL]
   sqlite3_step $VM
 } {SQLITE_DONE}
 do_test vacuum-4.2 {
   sqlite3_finalize $VM
 } SQLITE_OK
 
 # Ticket #515.  VACUUM after deleting and recreating the table that
 # a view refers to. Omit this test if the library is not view-enabled.
 #
 ifcapable view {
 do_test vacuum-5.1 {
   db close
-  file delete -force test.db
+  forcedelete test.db
   sqlite3 db test.db
   catchsql {
     CREATE TABLE Test (TestID int primary key);
     INSERT INTO Test VALUES (NULL);
     CREATE VIEW viewTest AS SELECT * FROM Test;
 
     BEGIN;
     CREATE TABLE tempTest (TestID int primary key, Test2 int NULL);
     INSERT INTO tempTest SELECT TestID, 1 FROM Test;
     DROP TABLE Test;
@@ skipping 35 matching lines @@
     }
   } {}
   do_test vacuum-6.4 {
     execsql {
       select count(*) from "abc abc" WHERE a = X'00112233';
     }
   } {1}
 }
 
 # Check what happens when an in-memory database is vacuumed. The
-# [file delete] command covers us in case the library was compiled
+# [delete_file] command covers us in case the library was compiled
 # without in-memory database support.
 #
-file delete -force :memory:
+forcedelete :memory:
 do_test vacuum-7.0 {
   sqlite3 db2 :memory:
   execsql {
     CREATE TABLE t1(t);
     VACUUM;
   } db2
 } {}
 do_test vacuum-7.1 {
   execsql {
     CREATE TABLE t2(t);
@@ skipping 23 matching lines @@
     execsql { PRAGMA auto_vacuum = 1} db2
     execsql { VACUUM } db2
     execsql { PRAGMA auto_vacuum } db2
   } {1}
 }
 db2 close
 
 # Ticket #873.  VACUUM a database that has ' in its name.
 #
 do_test vacuum-8.1 {
-  file delete -force a'z.db
-  file delete -force a'z.db-journal
+  forcedelete a'z.db
+  forcedelete a'z.db-journal
   sqlite3 db2 a'z.db
   execsql {
     CREATE TABLE t1(t);
     VACUUM;
   } db2
 } {}
 db2 close
 
 # Ticket #1095:  Vacuum a table that uses AUTOINCREMENT
 #
@@ skipping 24 matching lines @@
     expr {$::cksum!=""}
   } {1}
   do_test vacuum-9.4 {
     execsql {
       VACUUM;
     }
     cksum
   } $::cksum
 }
 
-file delete -force {a'z.db}
+forcedelete {a'z.db}
+
+# Test that "PRAGMA count_changes" does not interfere with VACUUM or cause
+# it to return any rows to the user.
+#
+do_test vacuum-10.1 {
+  db close
+  forcedelete test.db
+  sqlite3 db test.db
+  execsql {
+    CREATE TABLE t8(a, b);
+    INSERT INTO t8 VALUES('a', 'b');
+    INSERT INTO t8 VALUES('c', 'd');
+    PRAGMA count_changes = 1;
+  }
+} {}
+do_test vacuum-10.2 { execsql VACUUM } {}
 
 finish_test