[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/unixexcl.test

 # 2011 March 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 69 matching lines @@
   } {0 {hello world}}
 }
 
 do_multiclient_test tn {
   do_test unixexcl-3.$tn.1 {
     code1 { db close; sqlite3 db file:test.db?psow=0 -vfs unix-excl -uri 1 }
     code2 { db2 close; sqlite3 db2 file:test.db?psow=0 -vfs unix-excl -uri 1 }
     sql1 {
       PRAGMA auto_vacuum = 0;
       PRAGMA journal_mode = WAL;
+      PRAGMA synchronous = FULL;
       CREATE TABLE t1(a, b);
       INSERT INTO t1 VALUES(1, 2);
     }
   } {wal}
 
   if {$tn==1} {
     do_test unixexcl-3.$tn.1.multiproc {
       csql2 { SELECT * FROM t1; }
     } {1 {database is locked}}
   } else {
@@ skipping 19 matching lines @@
     do_test unixexcl-3.$tn.6 {
       sql2 { COMMIT; SELECT * FROM t1; }
     } {1 2 3 4}
     do_test unixexcl-3.$tn.7 {
       sql1 { PRAGMA wal_checkpoint; }
     } {0 7 7}
   }
 }
 
 finish_test