[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/pageropt.test

 # 2007 April 12
 #
 # 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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.
 # The focus of the tests in this file are to verify that the
 # pager optimizations implemented in version 3.3.14 work.
 #
 # $Id: pageropt.test,v 1.5 2008/08/20 14:49:25 danielk1977 Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
+do_not_use_codec
 
 ifcapable {!pager_pragmas||secure_delete||direct_read} {
   finish_test
   return
 }
 
+# A non-zero reserved_bytes value changes the number of pages in the 
+# database file, which messes up the results in this test.
+if {[nonzero_reserved_bytes]} {finish_test; return;}
+
 # Run the SQL statement supplied by the argument and return
 # the results.  Prepend four integers to the beginning of the
 # result which are
 #
 #     (1)  The number of page reads from the database
 #     (2)  The number of page writes to the database
 #     (3)  The number of page writes to the journal
 #     (4)  The number of cache pages freed
 #
 proc pagercount_sql {sql {db db}} {
@@ skipping 160 matching lines @@
   db close
   sqlite3 db test.db
   pagercount_sql {
     DELETE FROM t1
   }
 } {12 3 3}
 
 sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit)
 catch {db2 close}
 finish_test