Lines Matching refs:PRAGMA

13 # This file implements tests for the PRAGMA command.
25 # pragma2-4.*: Tests for PRAGMA cache_spill
42 db eval {PRAGMA auto_vacuum=0}
45 # EVIDENCE-OF: R-11211-21323 PRAGMA schema.freelist_count; Return the
50     PRAGMA freelist_count;
56     PRAGMA freelist_count;
62     PRAGMA freelist_count;
67     PRAGMA main.freelist_count;
78       PRAGMA aux.auto_vacuum=OFF;
79       PRAGMA aux.freelist_count;
85       PRAGMA aux.freelist_count;
92       PRAGMA aux.freelist_count;
101       PRAGMA aux.freelist_count;
107       PRAGMA aux.freelist_count;
108       PRAGMA main.freelist_count;
109       PRAGMA freelist_count;
114       PRAGMA freelist_count = 500;
115       PRAGMA freelist_count;
120       PRAGMA aux.freelist_count = 500;
121       PRAGMA aux.freelist_count;
126 # Default setting of PRAGMA cache_spill is always ON
128 # EVIDENCE-OF: R-63549-59887 PRAGMA cache_spill; PRAGMA
129 # cache_spill=boolean; PRAGMA schema.cache_spill=N;
138   PRAGMA main.cache_size=2000;
139   PRAGMA temp.cache_size=2000;
140   PRAGMA cache_spill;
141   PRAGMA main.cache_spill;
142   PRAGMA temp.cache_spill;
145   PRAGMA cache_spill=OFF;
146   PRAGMA cache_spill;
147   PRAGMA main.cache_spill;
148   PRAGMA temp.cache_spill;
151   PRAGMA page_size=1024;
152   PRAGMA cache_size=50;
168   PRAGMA cache_spill=ON;
180     PRAGMA lock_status;
186     PRAGMA cache_spill=OFF;
187     PRAGMA Cache_Spill;
190     PRAGMA lock_status;
195 # EVIDENCE-OF: R-34657-61226 The "PRAGMA cache_spill=N" form of this
201     PRAGMA cache_spill=100000;
202     PRAGMA cache_spill;
205     PRAGMA lock_status;
212       PRAGMA cache_spill=25;
213       PRAGMA main.cache_spill;
216       PRAGMA lock_status;
222       PRAGMA cache_spill(-25);
223       PRAGMA main.cache_spill;
226       PRAGMA lock_status;
237   PRAGMA cache_spill=OFF;
239   PRAGMA aux1.cache_size=50;
242   PRAGMA lock_status;
249   PRAGMA cache_spill=ON; -- Applies to all databases
252   PRAGMA lock_status;
259   PRAGMA page_size=16384;
261   PRAGMA cache_size=2;
262   PRAGMA cache_spill=YES;
263   PRAGMA cache_spill;
266   PRAGMA cache_spill=NO;
267   PRAGMA cache_spill;
270   PRAGMA cache_spill(-51);
271   PRAGMA cache_spill;