Import SQLite 3.10.2.

third_party/sqlite/src/test/pragma2.test

 # 2002 March 6
 #
 # 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 12 matching lines @@
 # pragma2-2.*: Test freelist_count pragma on an attached database.
 # pragma2-3.*: Test trying to write to the freelist_count is a no-op.
 # pragma2-4.*: Tests for PRAGMA cache_spill
 #
 
 ifcapable !pragma||!schema_pragmas {
   finish_test
   return
 }
 
+test_set_config_pagecache 0 0
+
 # Delete the preexisting database to avoid the special setup
 # that the "all.test" script does.
 #
 db close
 delete_file test.db test.db-journal
 delete_file test3.db test3.db-journal
 sqlite3 db test.db; set DB [sqlite3_connection_pointer db]
 db eval {PRAGMA auto_vacuum=0}
 
+
+# EVIDENCE-OF: R-11211-21323 PRAGMA schema.freelist_count; Return the
+# number of unused pages in the database file.
+#
 do_test pragma2-1.1 {
   execsql {
     PRAGMA freelist_count;
   }
 } {0}
 do_test pragma2-1.2 {
   execsql {
     CREATE TABLE abc(a, b, c);
     PRAGMA freelist_count;
   }
@@ skipping 60 matching lines @@
   do_test pragma2-3.3 {
     execsql {
       PRAGMA aux.freelist_count = 500;
       PRAGMA aux.freelist_count;
     }
   } {9 9}
 }
 
 # Default setting of PRAGMA cache_spill is always ON
 #
-# EVIDENCE-OF: R-51036-62828 PRAGMA cache_spill; PRAGMA
-# cache_spill=boolean;
+# EVIDENCE-OF: R-63549-59887 PRAGMA cache_spill; PRAGMA
+# cache_spill=boolean; PRAGMA schema.cache_spill=N;
 #
 # EVIDENCE-OF: R-23955-02765 Cache_spill is enabled by default
 #
 db close
 delete_file test.db test.db-journal
 delete_file test2.db test2.db-journal
 sqlite3 db test.db
 do_execsql_test pragma2-4.1 {
+  PRAGMA main.cache_size=2000;
+  PRAGMA temp.cache_size=2000;
   PRAGMA cache_spill;
   PRAGMA main.cache_spill;
   PRAGMA temp.cache_spill;
-} {1 1 1}
+} {2000 2000 2000}
 do_execsql_test pragma2-4.2 {
   PRAGMA cache_spill=OFF;
   PRAGMA cache_spill;
   PRAGMA main.cache_spill;
   PRAGMA temp.cache_spill;
 } {0 0 0}
 do_execsql_test pragma2-4.3 {
   PRAGMA page_size=1024;
   PRAGMA cache_size=50;
   BEGIN;
@@ skipping 19 matching lines @@
 # the ability of the pager to spill dirty cache pages to the database
 # file in the middle of a transaction.
 #
 do_test pragma2-4.4 {
   db eval {
     BEGIN;
     UPDATE t1 SET c=c+1;
     PRAGMA lock_status;
   }
 } {main exclusive temp unknown}  ;# EXCLUSIVE lock due to cache spill
-do_test pragma2-4.5 {
+do_test pragma2-4.5.1 {
   db eval {
-    COMMIT;
+    ROLLBACK;
     PRAGMA cache_spill=OFF;
+    PRAGMA Cache_Spill;
     BEGIN;
-    UPDATE t1 SET c=c-1;
+    UPDATE t1 SET c=c+1;
     PRAGMA lock_status;
   }
-} {main reserved temp unknown}   ;# No cache spill, so no exclusive lock
+} {0 main reserved temp unknown}   ;# No cache spill, so no exclusive lock
+
+
+# EVIDENCE-OF: R-34657-61226 The "PRAGMA cache_spill=N" form of this
+# pragma sets a minimum cache size threshold required for spilling to
+# occur.
+do_test pragma2-4.5.2 {
+  db eval {
+    ROLLBACK;
+    PRAGMA cache_spill=100000;
+    PRAGMA cache_spill;
+    BEGIN;
+    UPDATE t1 SET c=c+1;
+    PRAGMA lock_status;
+  }
+} {100000 main reserved temp unknown}   ;# Big spill threshold -> no excl lock
+ifcapable !memorymanage {
+  do_test pragma2-4.5.3 {
+    db eval {
+      ROLLBACK;
+      PRAGMA cache_spill=25;
+      PRAGMA main.cache_spill;
+      BEGIN;
+      UPDATE t1 SET c=c+1;
+      PRAGMA lock_status;
+    }
+  } {50 main exclusive temp unknown}   ;# Small cache spill -> exclusive lock
+  do_test pragma2-4.5.4 {
+    db eval {
+      ROLLBACK;
+      PRAGMA cache_spill(-25);
+      PRAGMA main.cache_spill;
+      BEGIN;
+      UPDATE t1 SET c=c+1;
+      PRAGMA lock_status;
+    }
+  } {50 main exclusive temp unknown}   ;# Small cache spill -> exclusive lock
+}
+
 
 # Verify that newly attached databases inherit the cache_spill=OFF
 # setting.
 #
 do_execsql_test pragma2-4.6 {
-  COMMIT;
+  ROLLBACK;
+  PRAGMA cache_spill=OFF;
   ATTACH 'test2.db' AS aux1;
   PRAGMA aux1.cache_size=50;
   BEGIN;
   UPDATE t2 SET c=c+1;
   PRAGMA lock_status;
 } {main unlocked temp unknown aux1 reserved}
 do_execsql_test pragma2-4.7 {
   COMMIT;
 }
 sqlite3_release_memory
 do_execsql_test pragma2-4.8 {
   PRAGMA cache_spill=ON; -- Applies to all databases
   BEGIN;
   UPDATE t2 SET c=c-1;
   PRAGMA lock_status;
 } {main unlocked temp unknown aux1 exclusive}
+db close
+forcedelete test.db
+sqlite3 db test.db
+
+breakpoint
+do_execsql_test pragma2-5.1 {
+  PRAGMA page_size=16384;
+  CREATE TABLE t1(x);
+  PRAGMA cache_size=2;
+  PRAGMA cache_spill=YES;
+  PRAGMA cache_spill;
+} {2}
+do_execsql_test pragma2-5.2 {
+  PRAGMA cache_spill=NO;
+  PRAGMA cache_spill;
+} {0}
+do_execsql_test pragma2-5.3 {
+  PRAGMA cache_spill(-51);
+  PRAGMA cache_spill;
+} {3}
    
-
+test_restore_config_pagecache
 finish_test