[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/exclusive.test

 # 2007 March 24
 #
 # 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 402 matching lines @@
 do_test exclusive-5.0 {
   execsql {
     CREATE TABLE abc(a UNIQUE, b UNIQUE, c UNIQUE);
     BEGIN;
     INSERT INTO abc VALUES(1, 2, 3);
     INSERT INTO abc SELECT a+1, b+1, c+1 FROM abc;
   }
 } {}
 do_test exclusive-5.1 {
   # Three files are open: The db, journal and statement-journal.
+  # (2016-03-04) The statement-journal is now opened lazily
   set sqlite_open_file_count
   expr $sqlite_open_file_count-$extrafds
-} [expr 3 - ($TEMP_STORE>=2)]
+} {2}
 do_test exclusive-5.2 {
   execsql {
     COMMIT;
   }
   # One file open: the db.
   set sqlite_open_file_count
   expr $sqlite_open_file_count-$extrafds
 } {1}
 do_test exclusive-5.3 {
   execsql {
     PRAGMA locking_mode = exclusive;
     BEGIN;
     INSERT INTO abc VALUES(5, 6, 7);
   }
   # Two files open: the db and journal.
   set sqlite_open_file_count
   expr $sqlite_open_file_count-$extrafds
 } {2}
 do_test exclusive-5.4 {
   execsql {
     INSERT INTO abc SELECT a+10, b+10, c+10 FROM abc;
   }
   # Three files are open: The db, journal and statement-journal.
+  # 2016-03-04: The statement-journal open is deferred
   set sqlite_open_file_count
   expr $sqlite_open_file_count-$extrafds
-} [expr 3 - ($TEMP_STORE>=2)]
+} {2}
 do_test exclusive-5.5 {
   execsql {
     COMMIT;
   }
   # Three files are still open: The db, journal and statement-journal.
+  # 2016-03-04: The statement-journal open is deferred
   set sqlite_open_file_count
   expr $sqlite_open_file_count-$extrafds
-} [expr 3 - ($TEMP_STORE>=2)]
+} {2}
 do_test exclusive-5.6 {
   execsql {
     PRAGMA locking_mode = normal;
     SELECT * FROM abc;
   }
 } {normal 1 2 3 2 3 4 5 6 7 11 12 13 12 13 14 15 16 17}
 do_test exclusive-5.7 {
   # Just the db open.
   set sqlite_open_file_count
   expr $sqlite_open_file_count-$extrafds
@@ skipping 29 matching lines @@
   close $fd
   sqlite3 db test.db
 } {}
 
 do_execsql_test exclusive-6.5 {
   PRAGMA locking_mode = EXCLUSIVE;
   SELECT * FROM sqlite_master;
 } {exclusive}
 
 finish_test