Lines Matching refs:PRAGMA
45 # pager1-6.*: Cases related to "PRAGMA max_page_count"
47 # pager1-7.*: Cases specific to "PRAGMA journal_mode=TRUNCATE"
56 # pager1-12.*: Tests involving "PRAGMA page_size"
58 # pager1-13.*: Cases specific to "PRAGMA journal_mode=PERSIST"
60 # pager1-14.*: Cases specific to "PRAGMA journal_mode=OFF"
66 # pager1-17.*: Tests related to "PRAGMA omit_readlock"
178 sql1 { PRAGMA lock_status }
181 sql2 { PRAGMA lock_status }
202 sql1 { PRAGMA lock_status }
274 PRAGMA cache_size = 10;
289 7 { PRAGMA synchronous = NORMAL ; PRAGMA temp_store = 0 } {
293 8 { PRAGMA synchronous = NORMAL ; PRAGMA temp_store = 2 } {
297 9 { PRAGMA synchronous = FULL } { }
298 10 { PRAGMA synchronous = NORMAL } { }
299 11 { PRAGMA synchronous = OFF } { }
300 12 { PRAGMA synchronous = FULL ; PRAGMA fullfsync = 1 } { }
301 13 { PRAGMA synchronous = FULL } {
305 14 { PRAGMA locking_mode = EXCLUSIVE } {
314 PRAGMA auto_vacuum = 2;
315 PRAGMA cache_size = 10;
329 execsql { PRAGMA auto_vacuum }
337 PRAGMA incremental_vacuum;
360 PRAGMA integrity_check;
389 # journal pointer generated in various "PRAGMA synchronous"
436 PRAGMA journal_mode = DELETE;
437 PRAGMA main.cache_size = 10;
438 PRAGMA aux.cache_size = 10;
462 PRAGMA integrity_check;
470 PRAGMA integrity_check;
478 PRAGMA integrity_check;
487 PRAGMA integrity_check;
502 PRAGMA journal_mode = DELETE;
595 PRAGMA main.synchronous=OFF;
596 PRAGMA aux.synchronous=OFF;
597 PRAGMA journal_mode = DELETE;
600 PRAGMA main.synchronous=OFF;
601 PRAGMA aux.synchronous=OFF;
602 PRAGMA main.page_size = 512;
603 PRAGMA aux.page_size = 512;
604 PRAGMA journal_mode = DELETE;
607 PRAGMA main.synchronous=NORMAL;
608 PRAGMA aux.synchronous=NORMAL;
609 PRAGMA journal_mode = DELETE;
612 PRAGMA main.synchronous=FULL;
613 PRAGMA aux.synchronous=FULL;
614 PRAGMA journal_mode = DELETE;
617 PRAGMA main.synchronous=NORMAL;
618 PRAGMA aux.synchronous=NORMAL;
619 PRAGMA journal_mode = WAL;
622 PRAGMA main.synchronous=NORMAL;
623 PRAGMA aux.synchronous=NORMAL;
624 PRAGMA main.journal_mode=DELETE;
625 PRAGMA aux.journal_mode=WAL;
628 PRAGMA main.synchronous=FULL;
629 PRAGMA aux.synchronous=OFF;
630 PRAGMA journal_mode=DELETE;
633 PRAGMA main.synchronous=OFF;
634 PRAGMA aux.synchronous=NORMAL;
635 PRAGMA journal_mode=DELETE;
638 PRAGMA main.synchronous=NORMAL;
639 PRAGMA aux.synchronous=NORMAL;
640 PRAGMA main.journal_mode=DELETE;
641 PRAGMA aux.journal_mode = MEMORY;
644 PRAGMA main.synchronous=NORMAL;
645 PRAGMA aux.synchronous=NORMAL;
646 PRAGMA main.journal_mode=DELETE;
647 PRAGMA aux.journal_mode = TRUNCATE;
650 PRAGMA main.synchronous=NORMAL;
651 PRAGMA aux.synchronous=NORMAL;
652 PRAGMA main.journal_mode=DELETE;
653 PRAGMA aux.journal_mode = PERSIST;
761 PRAGMA journal_mode = DELETE;
762 PRAGMA page_size = 1024;
839 PRAGMA journal_mode = DELETE;
870 PRAGMA journal_mode = DELETE;
938 PRAGMA journal_mode = DELETE;
1053 PRAGMA journal_mode = memory;
1062 PRAGMA journal_mode = off;
1089 PRAGMA journal_mode = DELETE;
1090 PRAGMA synchronous = NORMAL;
1121 PRAGMA synchronous = full;
1153 PRAGMA journal_mode = PERSIST;
1162 PRAGMA synchronous = full;
1173 # The following tests work with "PRAGMA max_page_count"
1178 PRAGMA auto_vacuum = none;
1179 PRAGMA max_page_count = 10;
1194 do_execsql_test pager1-6.4 { PRAGMA max_page_count } {10}
1195 do_execsql_test pager1-6.5 { PRAGMA max_page_count = 15 } {15}
1200 PRAGMA max_page_count = 13;
1204 PRAGMA max_page_count = 10;
1208 do_execsql_test pager1-6.10 { PRAGMA max_page_count = 10 } {11}
1210 do_execsql_test pager1-6.12 { PRAGMA max_page_count } {11}
1214 # The following tests work with "PRAGMA journal_mode=TRUNCATE" and
1215 # "PRAGMA locking_mode=EXCLUSIVE".
1233 PRAGMA auto_vacuum=OFF;
1234 PRAGMA synchronous=NORMAL;
1235 PRAGMA page_size=1024;
1236 PRAGMA locking_mode=EXCLUSIVE;
1237 PRAGMA journal_mode=TRUNCATE;
1253 4 { PRAGMA journal_mode = WAL } wal -1 -1
1255 6 { PRAGMA locking_mode = NORMAL } exclusive -1 [wal_file_size 1 1024]
1258 8 { PRAGMA journal_mode = TRUNCATE } truncate 0 -1
1273 PRAGMA locking_mode = EXCLUSIVE;
1276 PRAGMA journal_mode = delete;
1277 PRAGMA journal_mode = truncate;
1282 execsql { PRAGMA journal_mode = persist }
1287 PRAGMA journal_mode = persist;
1288 PRAGMA journal_size_limit;
1305 PRAGMA auto_vacuum = 1;
1342 PRAGMA cache_size = 10;
1358 db2 eval { PRAGMA cache_size = 10 }
1405 execsql { PRAGMA page_size = 1024 }
1414 PRAGMA page_size = 4096;
1415 PRAGMA synchronous = OFF;
1433 PRAGMA page_size = 4096;
1434 PRAGMA synchronous = OFF;
1454 PRAGMA page_size = 4096;
1486 PRAGMA journal_mode = PERSIST;
1487 PRAGMA page_size = 1024;
1512 PRAGMA cache_size = 10;
1548 PRAGMA auto_vacuum = none;
1549 PRAGMA page_size = 1024;
1583 PRAGMA journal_mode = DELETE;
1584 PRAGMA cache_size = 10;
1607 PRAGMA journal_mode = TRUNCATE;
1608 PRAGMA integrity_check;
1620 # Test "PRAGMA page_size"
1630 # page-size requested using "PRAGMA page_size" is greater than the
1640 PRAGMA page_size = $pagesize;
1649 PRAGMA main.page_size;
1655 PRAGMA main.page_size;
1664 # Test specal "PRAGMA journal_mode=PERSIST" test cases.
1700 PRAGMA page_size = 1024;
1701 PRAGMA journal_mode = PERSIST;
1702 PRAGMA cache_size = 10;
1727 do_execsql_test pager1-13.1.2.$nUp.2 { PRAGMA integrity_check } {ok}
1736 execsql { PRAGMA integrity_check } db2
1753 do_execsql_test pager1-13.2.2.$nUp.2 { PRAGMA integrity_check } {ok}
1759 execsql { PRAGMA integrity_check } db2
1769 # Test specal "PRAGMA journal_mode=OFF" test cases.
1773 # cannot be rolled back due to a prior "PRAGMA journal_mode=OFF". Which
1779 PRAGMA journal_mode = OFF;
1880 PRAGMA page_size = 1024;
1897 PRAGMA writable_schema = 1;
1954 PRAGMA writable_schema = 1;
1956 PRAGMA writable_schema = 0;
1969 PRAGMA page_size = 1024;
1988 PRAGMA page_size = 512;
1989 PRAGMA auto_vacuum = 1;
2055 PRAGMA locking_mode = exclusive;
2056 PRAGMA journal_mode = persist;
2073 PRAGMA cache_size = 10;
2074 PRAGMA journal_mode = wal;
2107 PRAGMA journal_mode = WAL;
2129 # Test that a "PRAGMA wal_checkpoint":
2141 execsql { PRAGMA wal_checkpoint }
2151 PRAGMA synchronous = off;
2152 PRAGMA journal_mode = WAL;
2155 execsql { PRAGMA wal_checkpoint }
2186 PRAGMA journal_mode = PERSIST;
2192 execsql { PRAGMA journal_mode = DELETE }
2198 PRAGMA journal_mode = PERSIST;
2202 db eval { PRAGMA journal_mode = DELETE }
2204 execsql { PRAGMA journal_mode }
2212 PRAGMA journal_mode = PERSIST;
2216 db eval { PRAGMA journal_mode = DELETE }
2217 execsql { PRAGMA journal_mode }
2228 PRAGMA journal_mode = PERSIST;
2232 db eval { PRAGMA journal_mode = DELETE }
2233 execsql { PRAGMA journal_mode }
2255 execsql "PRAGMA journal_mode = off"
2256 execsql "PRAGMA journal_mode = $mode"
2259 execsql "PRAGMA journal_mode = memory"
2260 execsql "PRAGMA journal_mode = $mode"
2264 execsql {PRAGMA locking_mode = normal}
2267 execsql {PRAGMA locking_mode = exclusive}
2270 execsql {PRAGMA locking_mode}
2273 execsql {PRAGMA main.locking_mode}
2282 PRAGMA cache_size = 10;
2283 PRAGMA auto_vacuum = FULL;
2307 PRAGMA integrity_check;
2322 PRAGMA integrity_check;
2369 PRAGMA page_size = 512;
2412 PRAGMA journal_mode = WAL;
2419 do_test pager1-28.$tn.3 { sql1 { PRAGMA locking_mode=exclusive } } {exclusive}
2438 PRAGMA journal_mode = PERSIST;
2444 do_test pager1-28.$tn.3 { sql1 { PRAGMA journal_mode = DELETE } } delete
2449 PRAGMA journal_mode = PERSIST;
2458 do_test pager1-28.$tn.9 { sql1 { PRAGMA journal_mode = DELETE } } delete
2467 PRAGMA journal_mode = PERSIST;
2475 do_test pager1-28.$tn.16 { sql1 { PRAGMA journal_mode = DELETE } } delete
2487 PRAGMA page_size = 1024;
2488 PRAGMA auto_vacuum = full;
2489 PRAGMA locking_mode=exclusive;
2499 PRAGMA page_size = 4096;
2506 PRAGMA page_size = 4096;
2530 PRAGMA locking_mode=EXCLUSIVE;
2532 PRAGMA lock_status;
2545 PRAGMA cache_size = 10;
2546 PRAGMA page_size = 1024;
2567 execsql { PRAGMA integrity_check } db2
2593 PRAGMA cache_size = 10;
2644 1 { PRAGMA mmap_size = 0 } 2400
2646 3 { PRAGMA mmap_size = 0 } 4400
2661 PRAGMA integrity_check;
2673 PRAGMA journal_mode = WAL;
2688 PRAGMA auto_vacuum = 0;
2694 sql2 { PRAGMA max_page_count = 2 }
2698 sql1 { PRAGMA checkpoint_fullfsync = 1 }
2754 PRAGMA auto_vacuum = 1;
2780 PRAGMA auto_vacuum = 2;
2792 PRAGMA cache_size = 1;
2793 PRAGMA incremental_vacuum;
2794 PRAGMA integrity_check;
2801 PRAGMA auto_vacuum = 1;
2804 PRAGMA page_count;
2818 PRAGMA cache_size = 1;
2820 PRAGMA integrity_check;
2844 PRAGMA cache_size = 1;
2846 PRAGMA integrity_check;
2871 db eval { PRAGMA mmap_size = 0 }
2913 db eval { PRAGMA mmap_size = 0 }
2935 PRAGMA page_size=4096;
2936 PRAGMA auto_vacuum=FULL;
2941 PRAGMA page_count;
2946 PRAGMA incremental_vacuum=50;
2947 PRAGMA page_count;
2948 PRAGMA max_page_count=2;
2952 PRAGMA page_count;
2953 PRAGMA max_page_count;