Import SQLite 3.7.6.3.

third_party/sqlite/src/test/shared2.test

 # 2005 January 19
 #
 # 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: shared2.test,v 1.8 2009/06/05 17:09:12 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
+source $testdir/lock_common.tcl
+source $testdir/malloc_common.tcl
 db close
 
 ifcapable !shared_cache {
   finish_test
   return
 }
 set ::enable_shared_cache [sqlite3_enable_shared_cache 1]
 
 # Test that if we delete all rows from a table any read-uncommitted 
 # cursors are correctly invalidated. Test on both table and index btrees.
@@ skipping 133 matching lines @@
   execsql { CREATE TABLE t2(a, b, c) }
   
   # The following statement would crash when attempting to sqlite3_free()
   # a pointer allocated from a lookaside buffer.
   execsql { CREATE INDEX i1 ON t2(a) } db2
 } {}
 
 db close
 db2 close
 
+# The following test verifies that shared-cache mode does not automatically
+# turn on exclusive-locking mode for some reason.
+do_multiclient_test {tn} {
+  sql1 { CREATE TABLE t1(a, b) }
+  sql2 { CREATE TABLE t2(a, b) }
+  do_test shared2-6.$tn.1 { sql1 { SELECT * FROM t2 } } {}
+  do_test shared2-6.$tn.2 { sql2 { SELECT * FROM t1 } } {}
+}
+
 sqlite3_enable_shared_cache $::enable_shared_cache
 finish_test