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

third_party/sqlite/src/test/corruptD.test

 # 2009 June 3
 #
 # 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.
 #
 #***********************************************************************
 #
 # $Id: corruptD.test,v 1.2 2009/06/05 17:09:12 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 # Do not use a codec for tests in this file, as the database file is
 # manipulated directly using tcl scripts (using the [hexio_write] command).
 #
 do_not_use_codec
 
+# These tests deal with corrupt database files
+#
+database_may_be_corrupt
+
 #--------------------------------------------------------------------------
 # OVERVIEW
 #
 #   This test file attempts to verify that SQLite does not read past the 
 #   end of any in-memory buffers as a result of corrupted database page 
 #   images. Usually this happens because a field within a database page
 #   that contains an offset to some other structure within the same page
 #   is set to too large a value. A database page contains the following
 #   such fields:
 #
@@ skipping 46 matching lines @@
   }
   for {set ii 1} {$ii < 50} {incr ii} {
     execsql { INSERT INTO t1 VALUES($ii, $ii * $ii) }
   }
   execsql {
     DELETE FROM t1 WHERE a = 10;
     DELETE FROM t1 WHERE a = 20;
     DELETE FROM t1 WHERE a = 30;
     DELETE FROM t1 WHERE a = 40;
   }
-  copy_file test.db test.bu
+  forcecopy test.db test.bu
 } {}
 
 proc incr_change_counter {} {
   hexio_write test.db 24 [
     hexio_render_int32 [expr [hexio_get_int [hexio_read test.db 24 4]] + 1]
   ]
 }
 
 proc restore_file {} {
   db close
-  copy_file test.bu test.db
+  forcecopy test.bu test.db
   sqlite3 db test.db
 }
 
 #-------------------------------------------------------------------------
 # The following tests, corruptD-1.1.*, focus on the page header field
 # containing the offset of the first free block in a page. 
 #
 do_test corruptD-1.1.1 {
   incr_change_counter
   hexio_write test.db [expr 1024+1] FFFF
-  catchsql { SELECT * FROM t1 }
+  catchsql { SELECT * FROM t1 ORDER BY rowid }
 } {1 {database disk image is malformed}}
 do_test corruptD-1.1.2 {
   incr_change_counter
   hexio_write test.db [expr 1024+1] [hexio_render_int32 1021]
-  catchsql { SELECT * FROM t1 }
+  catchsql { SELECT * FROM t1 ORDER BY rowid }
 } {1 {database disk image is malformed}}
 
 #-------------------------------------------------------------------------
 # The following tests, corruptD-1.2.*, focus on the offsets contained
 # in the first 2 byte of each free-block on the free-list.
 #
 do_test corruptD-1.2.1 {
   restore_file
 } {}
 do_test corruptD-1.2.2 {
 } {}
 
 #-------------------------------------------------------------------------
 # The following tests, corruptD-1.4.*, ...
 #
 
 
 #-------------------------------------------------------------------------
 # The following tests, corruptD-1.5.*, focus on the offsets contained
 # in the cell offset array.
 # 
 #   defragmentPage
 #
 
 finish_test