Import SQLite 3.7.6.3.

third_party/sqlite/src/test/tempdb.test

 # 2008 April 14
 #
 # 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 40 matching lines @@
     SELECT * FROM t1
   }
 } {}
 
 do_test tempdb-2.1 {
   # Set $::jrnl_in_memory if the journal file is expected to be in-memory.
   # Similarly, set $::subj_in_memory if the sub-journal file is expected
   # to be in memory. These variables are used to calculate the expected
   # number of open files in the test cases below.
   #
-  set jrnl_in_memory [expr {
-    [info exists ::permutations_test_prefix] &&
-    $::permutations_test_prefix eq "inmemory_journal"
-  }]
-  set subj_in_memory [expr {$jrnl_in_memory || $TEMP_STORE == 3}]
+  set jrnl_in_memory [expr {[permutation] eq "inmemory_journal"}]
+  set subj_in_memory [expr {$jrnl_in_memory || $TEMP_STORE>=2}]
 
   db close
   sqlite3 db test.db
 } {}
 do_test tempdb-2.2 {
   execsql {
     CREATE TABLE t1 (a PRIMARY KEY, b, c);
     CREATE TABLE t2 (a, b, c);
     BEGIN;
       INSERT INTO t1 VALUES(1, 2, 3);
       INSERT INTO t1 VALUES(4, 5, 6);
+      INSERT INTO t2 VALUES(7, 8, 9);
       INSERT INTO t2 SELECT * FROM t1;
   }
   catchsql { INSERT INTO t1 SELECT * FROM t2 }
   set sqlite_open_file_count
 } [expr 1 + (0==$jrnl_in_memory) + (0==$subj_in_memory)]
 do_test tempdb-2.3 {
   execsql {
     PRAGMA temp_store = 'memory';
     ROLLBACK;
     BEGIN;
       INSERT INTO t1 VALUES(1, 2, 3);
       INSERT INTO t1 VALUES(4, 5, 6);
       INSERT INTO t2 SELECT * FROM t1;
   }
   catchsql { INSERT INTO t1 SELECT * FROM t2 }
   set sqlite_open_file_count
 } [expr 1 + (0==$jrnl_in_memory)]
 
 finish_test