Import SQLite 3.10.2.

third_party/sqlite/src/test/pcache.test

 # 2008 August 29
 #
 # 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 55 matching lines @@
     CREATE TABLE t6(a, b, c);
     CREATE TABLE t7(a, b, c);
     CREATE TABLE t8(a, b, c);
     CREATE TABLE t9(a, b, c);
   }
   pcache_stats
 } {current 10 max 12 min 10 recyclable 0}
 
 do_test pcache-1.5 {
   sqlite3 db2 test.db
-  execsql "PRAGMA cache_size=10" db2
+  execsql "PRAGMA cache_size; PRAGMA cache_size=10" db2
   pcache_stats
 } {current 11 max 22 min 20 recyclable 1}
 
 do_test pcache-1.6.1 {
   execsql {
     BEGIN;
     SELECT * FROM sqlite_master;
   } db2
   pcache_stats
 } {current 11 max 22 min 20 recyclable 0}
@@ skipping 86 matching lines @@
     SELECT * FROM t5 ORDER BY a; SELECT * FROM t5;
     SELECT * FROM t6 ORDER BY a; SELECT * FROM t6;
     SELECT * FROM t7 ORDER BY a; SELECT * FROM t7;
     SELECT * FROM t8 ORDER BY a; SELECT * FROM t8;
     SELECT * FROM t9 ORDER BY a; SELECT * FROM t9;
   }
   pcache_stats
 } {current 14 max 15 min 10 recyclable 14}
 
 finish_test