[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/backup.test

 # 2009 January 30
 #
 # 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 146 matching lines @@
   sqlite3 db2 $zDestFile
   set db_dest db2
   set file_dest main
 } {
   sqlite3 db $zSrcFile
   sqlite3 db2 $zDestFile
   set db_dest db2
   set file_dest temp
 }] {
 foreach rows_dest {0 3 10} {
-foreach pgsz_dest {512 1024 2048} {
+foreach pgsz_dest {512 1024 2048 4096} {
 foreach nPagePerStep {1 200} {
 
   # Open the databases.
   catch { delete_file test.db }
   catch { delete_file test2.db }
   eval $zOpenScript
 
   # Set to true if copying to an in-memory destination. Copying to an 
   # in-memory destination is only possible if the initial destination
   # page size is the same as the source page size (in this case 1024 bytes).
   #
-  set isMemDest [expr {
-    $zDestFile eq ":memory:" || $file_dest eq "temp" && $TEMP_STORE>=2
-  }]
+  set isMemDest [expr { $zDestFile eq ":memory:" || $file_dest eq "temp" }]
 
-  if { $isMemDest==0 || $pgsz_dest == 1024 } {
-    if 0 {
-      puts -nonewline "Test $iTest: src=$zSrcFile dest=$zDestFile"
-      puts -nonewline " (as $db_dest.$file_dest)"
-      puts -nonewline " rows_dest=$rows_dest pgsz_dest=$pgsz_dest"
-      puts ""
-    }
+  if 0 {
+    puts -nonewline "Test $iTest: src=$zSrcFile dest=$zDestFile"
+    puts -nonewline " (as $db_dest.$file_dest)"
+    puts -nonewline " rows_dest=$rows_dest pgsz_dest=$pgsz_dest"
+    puts ""
+  }
+
+  if { $isMemDest==0 || $pgsz_dest==1024 || $rows_dest==0 } {
 
     # Set up the content of the source database.
     execsql {
       PRAGMA page_size = 1024;
       BEGIN;
       CREATE TABLE t1(a, b);
       CREATE INDEX i1 ON t1(a, b);
       INSERT INTO t1 VALUES(1, randstr(1000,1000));
       INSERT INTO t1 VALUES(2, randstr(1000,1000));
       INSERT INTO t1 VALUES(3, randstr(1000,1000));
@@ skipping 764 matching lines @@
   } $rc
 
   do_test backup-10.$tn.6 {
     B finish
   } {SQLITE_OK}
 
   db2 close
 }
 
 finish_test