Import SQLite 3.8.7.4.

third_party/sqlite/src/test/pager2.test

 # 2010 June 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 100 matching lines @@
         PRAGMA integrity_check;
       } [list $x ok]
     }
   }
 }
 db close
 tv delete
 
 
 #-------------------------------------------------------------------------
-#
 # pager2-2.1: Test a ROLLBACK with journal_mode=off.
 # pager2-2.2: Test shrinking the database (auto-vacuum) with 
 #             journal_mode=off
 #
 do_test pager2-2.1 {
   faultsim_delete_and_reopen
   execsql {
     CREATE TABLE t1(a, b);
     PRAGMA journal_mode = off;
     BEGIN;
       INSERT INTO t1 VALUES(1, 2);
     ROLLBACK;
     SELECT * FROM t1;
   }
 } {off}
 do_test pager2-2.2 {
   faultsim_delete_and_reopen
   execsql {
     PRAGMA auto_vacuum = incremental;
     PRAGMA page_size = 1024;
     PRAGMA journal_mode = off;
     CREATE TABLE t1(a, b);
     INSERT INTO t1 VALUES(zeroblob(5000), zeroblob(5000));
     DELETE FROM t1;
     PRAGMA incremental_vacuum;
   }
   file size test.db
 } {3072}
 
+#-------------------------------------------------------------------------
+# Test that shared in-memory databases seem to work.
+#
+db close
+do_test pager2-3.1 {
+  forcedelete test.db
+  sqlite3_shutdown
+  sqlite3_config_uri 1
+
+  sqlite3 db1 {file:test.db?mode=memory&cache=shared}
+  sqlite3 db2 {file:test.db?mode=memory&cache=shared}
+  sqlite3 db3 test.db
+
+  db1 eval { CREATE TABLE t1(a, b) }
+  db2 eval { INSERT INTO t1 VALUES(1, 2) }
+  list [catch { db3 eval { INSERT INTO t1 VALUES(3, 4) } } msg] $msg
+} {1 {no such table: t1}}
+
 finish_test