[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/nolock.test

 # 2014-05-07
 #
 # 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 164 matching lines @@
 } {hello world 12345 67890}
 do_test nolock-3.12 {
   list xLock $::tvfs_calls(xLock) xUnlock $::tvfs_calls(xUnlock) \
        xCheckReservedLock $::tvfs_calls(xCheckReservedLock) \
        xAccess $::tvfs_calls(xAccess)
 } {xLock 0 xUnlock 0 xCheckReservedLock 0 xAccess 0}
 
 db2 close
 db close
 tvfs delete
+
+if {[permutation]!="inmemory_journal"} {
+  # 2016-03-11:  Make sure all works when transitioning to WAL mode
+  # under nolock.
+  #
+  do_test nolock-4.1 {
+    forcedelete test.db
+    sqlite3 db file:test.db?nolock=1 -uri 1
+    db eval {
+       PRAGMA journal_mode=WAL;
+       CREATE TABLE t1(x);
+       INSERT INTO t1 VALUES('youngling');
+       SELECT * FROM t1;
+    }
+  } {delete youngling}
+  db close
+  
+  do_test nolock-4.2 {
+    forcedelete test.db
+    sqlite3 db test.db
+    db eval {
+      PRAGMA journal_mode=WAL;
+      CREATE TABLE t1(x);
+      INSERT INTO t1 VALUES('catbird');
+      SELECT * FROM t1;
+    }
+  } {wal catbird}
+  do_test nolock-4.3 {
+    db close
+    sqlite3 db file:test.db?nolock=1 -uri 1
+    set rc [catch {db eval {SELECT * FROM t1}} msg]
+    lappend rc $msg
+  } {1 {unable to open database file}}
+}
+
 finish_test