Import SQLite 3.8.7.4.

third_party/sqlite/src/test/filefmt.test

 # 2007 April 6
 #
 # 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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.
 #
 # This file implements tests to verify database file format.
 #
 # $Id: filefmt.test,v 1.3 2009/06/18 11:34:43 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
 
 db close
-file delete -force test.db test.db-journal
+forcedelete test.db test.db-journal
 
 # Database begins with valid 16-byte header string.
 #
 do_test filefmt-1.1 {
   sqlite3 db test.db
   db eval {CREATE TABLE t1(x)}
   db close
   hexio_read test.db 0 16
 } {53514C69746520666F726D6174203300}
 
@@ skipping 19 matching lines @@
 } {0 1}
 
 # The page-size is stored at offset 16
 #
 ifcapable pager_pragmas {
   foreach pagesize {512 1024 2048 4096 8192 16384 32768} {
      if {[info exists SQLITE_MAX_PAGE_SIZE]
           && $pagesize>$SQLITE_MAX_PAGE_SIZE} continue
      do_test filefmt-1.5.$pagesize.1 {
        db close
-       file delete -force test.db
+       forcedelete test.db
        sqlite3 db test.db
        db eval "PRAGMA auto_vacuum=OFF"
        db eval "PRAGMA page_size=$pagesize"
        db eval {CREATE TABLE t1(x)}
        file size test.db
      } [expr $pagesize*2]
      do_test filefmt-1.5.$pagesize.2 {
        hexio_get_int [hexio_read test.db 16 2]
      } $pagesize
   }
@@ skipping 21 matching lines @@
      SELECT count(*) FROM sqlite_master
   }
 } {1 {file is encrypted or is not a database}}
 
 # Usable space per page (page-size minus unused space per page)
 # must be at least 480 bytes
 #
 ifcapable pager_pragmas {
   do_test filefmt-1.8 {
     db close
-    file delete -force test.db
+    forcedelete test.db
     sqlite3 db test.db
     db eval {PRAGMA page_size=512; CREATE TABLE t1(x)}
     db close
     hexio_write test.db 20 21
     sqlite3 db test.db
     catchsql {
        SELECT count(*) FROM sqlite_master
     }
   } {1 {file is encrypted or is not a database}}
 }
 
 #-------------------------------------------------------------------------
 # The following block of tests - filefmt-2.* - test that versions 3.7.0
 # and later can read and write databases that have been modified or created
 # by 3.6.23.1 and earlier. The difference difference is that 3.7.0 stores
 # the size of the database in the database file header, whereas 3.6.23.1
 # always derives this from the size of the file.
 #
 db close
-file delete -force test.db
+forcedelete test.db
 
 set a_string_counter 1
 proc a_string {n} {
   incr ::a_string_counter
   string range [string repeat "${::a_string_counter}." $n] 1 $n
 }
 sqlite3 db test.db
 db func a_string a_string
 
 do_execsql_test filefmt-2.1.1 {
@@ skipping 11 matching lines @@
 
 do_test filefmt-2.1.3 {
   sql36231 { INSERT INTO t1 VALUES(a_string(3000)) }
 } {}
 
 do_execsql_test filefmt-2.1.4 { INSERT INTO t2 VALUES(2) } {}
 integrity_check filefmt-2.1.5
 do_test         filefmt-2.1.6 { hexio_read test.db 28 4 } {00000010}
 
 db close
-file delete -force test.db
+forcedelete test.db
 sqlite3 db test.db
 db func a_string a_string
 
 do_execsql_test filefmt-2.2.1 {
   PRAGMA page_size = 1024;
   PRAGMA auto_vacuum = 0;
   CREATE TABLE t1(a);
   CREATE INDEX i1 ON t1(a);
   INSERT INTO t1 VALUES(a_string(3000));
   CREATE TABLE t2(a);
@@ skipping 35 matching lines @@
   CREATE TABLE t1(a, b);
 } {}
 do_test filefmt-3.2 { 
   sql36231 { DROP TABLE t1 } 
 } {}
 do_execsql_test filefmt-3.3 {
   SELECT * FROM sqlite_master;
   PRAGMA integrity_check;
 } {ok}
 
+reset_db
+do_execsql_test filefmt-4.1 {
+  PRAGMA auto_vacuum = 1;
+  CREATE TABLE t1(x, y);
+  CREATE TABLE t2(x, y);
+
+  INSERT INTO t1 VALUES(randomblob(100), randomblob(100));
+  INSERT INTO t1 VALUES(randomblob(100), randomblob(100));
+  INSERT INTO t1 VALUES(randomblob(100), randomblob(100));
+  INSERT INTO t1 VALUES(randomblob(100), randomblob(100));
+  INSERT INTO t1 VALUES(randomblob(100), randomblob(100));
+  INSERT INTO t1 VALUES(randomblob(100), randomblob(100));
+
+  INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1;
+  INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1;
+  INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1;
+  INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM t1;
+}
+
+do_test filefmt-4.2 { 
+  sql36231 { INSERT INTO t2 SELECT * FROM t1 }
+} {}
+
+do_test filefmt-4.3 { 
+  forcedelete bak.db
+  db backup bak.db
+} {}
+
+do_test filefmt-4.4 { 
+  sqlite3 db2 bak.db
+  db2 eval { PRAGMA integrity_check }
+} {ok}
+db2 close
+
 finish_test