Searched refs:PRAGMA (Results 1 – 25 of 570) sorted by relevance
12345678910>>...23
51 PRAGMA journal_mode;52 PRAGMA main.journal_mode;53 PRAGMA temp.journal_mode;63 PRAGMA journal_mode;64 PRAGMA main.journal_mode;65 PRAGMA temp.journal_mode;84 PRAGMA journal_mode;85 PRAGMA main.journal_mode;96 PRAGMA journal_mode;108 PRAGMA journal_mode;[all …]
86 # EVIDENCE-OF: R-13861-56665 PRAGMA schema.cache_size; PRAGMA96 PRAGMA cache_size;107 PRAGMA cache_size;116 PRAGMA cache_size;124 PRAGMA cache_size;132 PRAGMA cache_size;140 PRAGMA cache_size;149 PRAGMA cache_size;157 PRAGMA cache_size;886 # Test cases pragma-8.* test the "PRAGMA schema_version" and "PRAGMA[all …]
128 # EVIDENCE-OF: R-63549-59887 PRAGMA cache_spill; PRAGMA140 PRAGMA cache_spill;146 PRAGMA cache_spill;152 PRAGMA cache_size=50;180 PRAGMA lock_status;242 PRAGMA lock_status;252 PRAGMA lock_status;261 PRAGMA cache_size=2;263 PRAGMA cache_spill;267 PRAGMA cache_spill;[all …]
13 # "PRAGMA journal_mode=WAL" mode.202 PRAGMA main.journal_mode;212 PRAGMA main.journal_mode;235 PRAGMA main.journal_mode;245 PRAGMA main.journal_mode;263 PRAGMA temp.journal_mode;273 PRAGMA temp.journal_mode;292 PRAGMA journal_mode = wal;307 PRAGMA journal_mode = WAL;345 PRAGMA journal_mode = WAL;[all …]
25 PRAGMA data_version;44 PRAGMA data_version;46 PRAGMA data_version;49 PRAGMA data_version;52 PRAGMA data_version;64 PRAGMA data_version;66 PRAGMA data_version;68 PRAGMA data_version;71 PRAGMA data_version;72 PRAGMA shrink_memory;[all …]
42 PRAGMA page_size=4096;50 PRAGMA journal_mode;51 PRAGMA page_count;61 PRAGMA page_count;93 PRAGMA page_size;118 PRAGMA page_size;119 PRAGMA page_count;127 PRAGMA page_size;136 PRAGMA quick_check228 PRAGMA page_count;[all …]
33 3 "PRAGMA auto_vacuum = 1"35 5 "PRAGMA cache_spill = 1"43 13 "PRAGMA foreign_keys = 1"45 15 "PRAGMA fullfsync = 1"47 18 "PRAGMA page_size = 511"48 19 "PRAGMA page_size = 512"72 1 "PRAGMA shrink_memory"91 PRAGMA page_size=512;126 PRAGMA table_info(t1) 130 PRAGMA table_info(t1) [all …]
38 PRAGMA page_size=2048;39 PRAGMA page_size;48 PRAGMA page_size=511;49 PRAGMA page_size;54 PRAGMA page_size=512;55 PRAGMA page_size;62 PRAGMA page_size;68 PRAGMA page_size;74 PRAGMA page_size107 PRAGMA page_size;[all …]
54 1.1 { PRAGMA mmap_size = 67108864 } /[49]/ {PRAGMA mmap_size = 0}55 1.2 { PRAGMA mmap_size = 53248 } 150 {PRAGMA mmap_size = 0}56 1.3 { PRAGMA mmap_size = 0 } 344 {PRAGMA mmap_size = 0}57 1.4 { PRAGMA mmap_size = 67108864 } /[49]/ {PRAGMA mmap_size = 67108864 }58 1.5 { PRAGMA mmap_size = 53248 } 150 {PRAGMA mmap_size = 67108864 }59 1.6 { PRAGMA mmap_size = 0 } 344 {PRAGMA mmap_size = 67108864 }84 sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"90 sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"96 sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"139 PRAGMA auto_vacuum;[all …]
34 PRAGMA mmap_size;42 PRAGMA quick_check;43 PRAGMA mmap_size;51 PRAGMA quick_check;52 PRAGMA mmap_size;60 PRAGMA quick_check;61 PRAGMA mmap_size;70 PRAGMA mmap_size;79 PRAGMA mmap_size;88 PRAGMA mmap_size;[all …]
15 # EVIDENCE-OF: R-15402-03103 PRAGMA schema.foreign_key_check; PRAGMA73 PRAGMA foreign_key_check;79 PRAGMA foreign_key_check;134 PRAGMA foreign_key_check;155 PRAGMA foreign_key_check;173 PRAGMA foreign_key_check;185 PRAGMA foreign_key_check;197 PRAGMA foreign_key_check;411 PRAGMA foreign_key_check;418 PRAGMA foreign_key_check;[all …]
38 PRAGMA db2.secure_delete;44 PRAGMA db2.secure_delete;49 PRAGMA secure_delete=OFF;50 PRAGMA db2.secure_delete;55 PRAGMA secure_delete=ON;56 PRAGMA db2.secure_delete;62 PRAGMA db2.secure_delete;67 PRAGMA secure_delete=ON;68 PRAGMA db2.secure_delete;74 PRAGMA db2.secure_delete;[all …]
40 PRAGMA writable_schema=on;46 PRAGMA quick_check('t1');50 PRAGMA quick_check('t1');54 PRAGMA quick_check('t1');58 PRAGMA quick_check('t1');76 PRAGMA quick_check('t1');80 PRAGMA quick_check('t1');84 PRAGMA quick_check('t1');88 PRAGMA quick_check('t1');102 PRAGMA quick_check('t1');[all …]
41 PRAGMA page_size = 1024;42 PRAGMA auto_vacuum = 0;43 PRAGMA journal_mode = wal;59 PRAGMA main.journal_mode;72 PRAGMA main.journal_mode;107 PRAGMA integrity_check;213 db eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }220 db eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }227 db eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }228 db2 eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = PERSIST }[all …]
30 PRAGMA temp.integrity_check;56 PRAGMA main.cache_size = 10;57 PRAGMA temp.cache_size = 10;102 PRAGMA temp.page_count;223 PRAGMA integrity_check;232 PRAGMA auto_vacuum = OFF;237 PRAGMA page_count;249 PRAGMA page_count;263 PRAGMA page_size;333 PRAGMA cache_size = 50;[all …]
44 PRAGMA auto_vacuum = 0;45 PRAGMA journal_mode = wal;51 PRAGMA wal_checkpoint;67 PRAGMA wal_checkpoint;94 PRAGMA wal_checkpoint;102 PRAGMA wal_checkpoint;141 PRAGMA wal_checkpoint161 PRAGMA wal_checkpoint220 PRAGMA auto_vacuum = 0;364 PRAGMA wal_checkpoint[all …]
274 PRAGMA cache_size = 10;289 7 { PRAGMA synchronous = NORMAL ; PRAGMA temp_store = 0 } {293 8 { PRAGMA synchronous = NORMAL ; PRAGMA temp_store = 2 } {300 12 { PRAGMA synchronous = FULL ; PRAGMA fullfsync = 1 } { }2532 PRAGMA lock_status;2804 PRAGMA page_count;2935 PRAGMA page_size=4096;2941 PRAGMA page_count;2947 PRAGMA page_count;2952 PRAGMA page_count;[all …]
13 # "PRAGMA journal_mode=WAL" mode.26 # PRAGMA journal_mode = WAL;71 PRAGMA journal_mode = WAL;76 PRAGMA wal_checkpoint;106 PRAGMA auto_vacuum = 1;119 PRAGMA wal_checkpoint;139 PRAGMA wal_checkpoint;155 PRAGMA page_size = 512;196 PRAGMA page_size = 512;237 PRAGMA page_size = 512;[all …]
138 PRAGMA auto_vacuum = 2;163 PRAGMA auto_vacuum = 1;177 PRAGMA auto_vacuum = 2;281 PRAGMA incremental_vacuum;511 PRAGMA cache_size = 10;602 PRAGMA auto_vacuum;608 PRAGMA auto_vacuum;619 PRAGMA auto_vacuum;637 PRAGMA auto_vacuum;710 PRAGMA auto_vacuum;[all …]
35 PRAGMA auto_vacuum=OFF;36 PRAGMA page_size = 1024;82 PRAGMA page_size = 1024;212 PRAGMA page_size=1024;242 PRAGMA page_size=1024;255 PRAGMA page_size=4096;262 PRAGMA page_size285 PRAGMA page_size = 1024;288 PRAGMA page_size = 4096;292 PRAGMA page_size = 2048;[all …]
34 PRAGMA defer_foreign_keys;38 PRAGMA foreign_keys=ON;91 PRAGMA defer_foreign_keys;93 PRAGMA defer_foreign_keys;96 PRAGMA defer_foreign_keys;98 PRAGMA defer_foreign_keys;137 PRAGMA defer_foreign_keys;144 PRAGMA vdbe_trace = 0;146 PRAGMA defer_foreign_keys;155 PRAGMA defer_foreign_keys;[all …]
13 # Specificly, it tests that "PRAGMA synchronous" appears to work.61 do_execsql_test 1.2.1 { PRAGMA main.synchronous = NORMAL }62 do_execsql_test 1.2.2 { PRAGMA main.synchronous } 166 do_execsql_test 1.3.1 { PRAGMA main.synchronous = OFF }67 do_execsql_test 1.3.2 { PRAGMA main.synchronous } 072 do_execsql_test 1.4.1 { PRAGMA main.synchronous = FULL }73 do_execsql_test 1.4.2 { PRAGMA main.synchronous } 279 do_execsql_test 1.5 { PRAGMA journal_mode = wal } {wal}97 do_execsql_test 1.10.1 { PRAGMA main.synchronous = OFF }138 do_execsql_test 1.16 { PRAGMA journal_mode = wal } {wal}[all …]
13 # "PRAGMA journal_mode=WAL" mode.287 PRAGMA wal_checkpoint;387 PRAGMA auto_vacuum = 1;389 PRAGMA auto_vacuum;403 PRAGMA wal_checkpoint;410 PRAGMA wal_checkpoint;421 PRAGMA cache_size=2000;810 PRAGMA wal_checkpoint;812 PRAGMA wal_checkpoint;814 PRAGMA wal_checkpoint;[all …]
4 PRAGMA page_size=512;6 PRAGMA mmap_size=0;9 PRAGMA mmap_size=28672;12 PRAGMA mmap_size=8192;15 PRAGMA mmap_size=65536;18 PRAGMA mmap_size=268435456;22 PRAGMA page_size=1024;45 PRAGMA page_size=2048;68 PRAGMA page_size=8192;91 PRAGMA page_size=16384;[all …]
5 PRAGMA page_size=8192;7 PRAGMA journal_mode=PERSIST;8 PRAGMA mmap_size=0;11 PRAGMA journal_mode=TRUNCATE;12 PRAGMA mmap_size=28672;15 PRAGMA journal_mode=MEMORY;18 PRAGMA journal_mode=OFF;21 PRAGMA mmap_size(268435456);25 PRAGMA page_size=16384;29 INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));[all …]