[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/io.test

 # 2007 August 21
 #
 # 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 406 matching lines @@
     # have been no calls to fsync(). The file is probably about 30KB.
     # But some VFS implementations (symbian) buffer writes so the actual
     # size may be a little less than that. So this test case just tests
     # that the file is now greater than 20000 bytes in size.
     list [expr [file size test.db]>20000] [nSync]
   } {1 0}
   do_test io-3.3 {
     # The COMMIT requires a single fsync() - to the database file.
     execsql { COMMIT }
     list [file size test.db] [nSync]
-  } {39936 1}
+  } "[expr {[nonzero_reserved_bytes]?40960:39936}] 1"
 }
 
 #----------------------------------------------------------------------
 # Test cases io-4.* test the IOCAP_SAFE_APPEND optimization.
 #
 sqlite3_simulate_device -char safe_append
 
 # With the SAFE_APPEND flag set, simple transactions require 3, rather
 # than 4, calls to fsync(). The fsync() calls are on:
 #
@@ skipping 196 matching lines @@
   # database should be cached in the pager-cache. If corruption is
   # reported, it indicates that executing $sql caused the pager cache
   # to be flushed. Which is a bug.
   hexio_write test.db [expr 1024 * 5] [string repeat 00 2048]
   do_execsql_test 6.2.$tn.3 { PRAGMA integrity_check } {ok}
   db close
 }
 
 sqlite3_simulate_device -char {} -sectorsize 0
 finish_test