Lines Matching refs:PRAGMA
13 # This file implements tests for the PRAGMA command.
45 # pragma-22.*: Test that "PRAGMA [db].integrity_check" respects the "db"
86 # EVIDENCE-OF: R-13861-56665 PRAGMA schema.cache_size; PRAGMA
87 # schema.cache_size = pages; PRAGMA schema.cache_size = -kibibytes;
92 set DFLT_CACHE_SZ [db one {PRAGMA default_cache_size}]
93 set TEMP_CACHE_SZ [db one {PRAGMA temp.default_cache_size}]
96 PRAGMA cache_size;
97 PRAGMA default_cache_size;
98 PRAGMA synchronous;
105 PRAGMA synchronous=OFF;
106 PRAGMA cache_size=1234;
107 PRAGMA cache_size;
108 PRAGMA default_cache_size;
109 PRAGMA synchronous;
116 PRAGMA cache_size;
117 PRAGMA default_cache_size;
118 PRAGMA synchronous;
123 PRAGMA synchronous=OFF;
124 PRAGMA cache_size;
125 PRAGMA default_cache_size;
126 PRAGMA synchronous;
131 PRAGMA cache_size=-4321;
132 PRAGMA cache_size;
133 PRAGMA default_cache_size;
134 PRAGMA synchronous;
139 PRAGMA synchronous=ON;
140 PRAGMA cache_size;
141 PRAGMA default_cache_size;
142 PRAGMA synchronous;
149 PRAGMA cache_size;
150 PRAGMA default_cache_size;
151 PRAGMA synchronous;
156 PRAGMA default_cache_size=-123;
157 PRAGMA cache_size;
158 PRAGMA default_cache_size;
159 PRAGMA synchronous;
166 PRAGMA cache_size;
167 PRAGMA default_cache_size;
168 PRAGMA synchronous;
175 PRAGMA cache_size;
176 PRAGMA default_cache_size;
177 PRAGMA synchronous;
183 PRAGMA synchronous=NORMAL;
184 PRAGMA cache_size;
185 PRAGMA default_cache_size;
186 PRAGMA synchronous;
191 PRAGMA synchronous=EXTRA;
192 PRAGMA cache_size;
193 PRAGMA default_cache_size;
194 PRAGMA synchronous;
199 PRAGMA synchronous=FULL;
200 PRAGMA cache_size;
201 PRAGMA default_cache_size;
202 PRAGMA synchronous;
209 PRAGMA cache_size;
210 PRAGMA default_cache_size;
211 PRAGMA synchronous;
220 PRAGMA synchronous=0;
221 PRAGMA synchronous;
226 PRAGMA synchronous=2;
227 PRAGMA synchronous;
232 PRAGMA synchronous=4;
233 PRAGMA synchronous;
238 PRAGMA synchronous=3;
239 PRAGMA synchronous;
244 PRAGMA synchronous=8;
245 PRAGMA synchronous;
250 PRAGMA synchronous=10;
251 PRAGMA synchronous;
256 PRAGMA default_cache_size = 0;
259 PRAGMA default_cache_size;
262 PRAGMA default_cache_size = -500;
265 PRAGMA default_cache_size;
268 PRAGMA default_cache_size = 500;
271 PRAGMA default_cache_size;
277 PRAGMA default_cache_size;
288 PRAGMA vdbe_listing=YES;
289 PRAGMA vdbe_listing;
294 PRAGMA vdbe_listing=NO;
295 PRAGMA vdbe_listing;
302 PRAGMA parser_trace=ON;
303 PRAGMA parser_trace=OFF;
308 PRAGMA bogus = -1234; -- Parsing of negative values
352 PRAGMA auto_vacuum=OFF;
366 set pgsz [db eval {PRAGMA page_size}]
374 execsql {PRAGMA integrity_check}
377 execsql {PRAGMA integrity_check=1}
382 PRAGMA integrity_check
387 PRAGMA integrity_check=4
391 PRAGMA integrity_check=xyz
394 PRAGMA integrity_check=t2
397 PRAGMA integrity_check=sqlite_schema
401 PRAGMA integrity_check=0
422 execsql {PRAGMA integrity_check}
425 execsql {PRAGMA quick_check}
428 execsql {PRAGMA QUICK_CHECK}
433 PRAGMA integrity_check
440 PRAGMA t2.integrity_check=t2;
443 PRAGMA t2.integrity_check=sqlite_schema;
447 PRAGMA integrity_check=1
453 PRAGMA integrity_check=5
461 PRAGMA integrity_check=4
469 PRAGMA integrity_check=3
477 PRAGMA integrity_check(2)
485 PRAGMA integrity_check
496 PRAGMA integrity_check(10)
507 PRAGMA integrity_check=8
517 PRAGMA integrity_check=4
528 db eval {PRAGMA integrity_check}
532 # Verify that PRAGMA integrity_check catches UNIQUE and NOT NULL
541 PRAGMA writable_schema=ON;
546 PRAGMA writable_schema=OFF;
548 PRAGMA integrity_check;
551 PRAGMA integrity_check(3);
554 PRAGMA integrity_check(2);
557 PRAGMA integrity_check(1);
561 # PRAGMA integrity check (or more specifically the sqlite3BtreeCount()
580 db eval {PRAGMA integrity_check} {
690 PRAGMA table_info(t5);
747 capture_pragma db out {PRAGMA index_xinfo(t3i1)}
752 # EVIDENCE-OF: R-29448-60346 PRAGMA schema.index_info(index-name); This
755 # (The first column of output from PRAGMA index_info is...)
759 # (The second column of output from PRAGMA index_info is...)
763 # (The third column of output from PRAGMA index_info is...)
768 PRAGMA index_info='t3i2';
790 PRAGMA table_info(trial);
795 PRAGMA temp.table_info(trial);
800 PRAGMA main.table_info(trial);
815 capture_pragma db out {PRAGMA table_info(test_table)}
828 PRAGMA table_info(t68);
839 # EVIDENCE-OF: R-64103-17776 PRAGMA schema.index_list(table-name); This
846 capture_pragma db out "PRAGMA index_list(t3)"
886 # Test cases pragma-8.* test the "PRAGMA schema_version" and "PRAGMA
889 # pragma-8.1: PRAGMA schema_version
890 # pragma-8.2: PRAGMA user_version
899 PRAGMA schema_version = 105;
904 PRAGMA schema_version;
909 PRAGMA schema_version = 106;
910 PRAGMA schema_version;
914 PRAGMA schema_version = 106;
915 PRAGMA schema_version;
929 PRAGMA schema_version;
945 PRAGMA schema_version = 108;
964 PRAGMA aux.schema_version = 205;
969 PRAGMA aux.schema_version;
975 PRAGMA schema_version;
991 PRAGMA aux.schema_version = 206;
1010 PRAGMA user_version;
1015 PRAGMA user_version = 2;
1020 PRAGMA user_version;
1027 PRAGMA user_version;
1032 PRAGMA schema_version;
1039 PRAGMA user_version;
1044 PRAGMA schema_version;
1056 PRAGMA aux.user_version;
1061 PRAGMA aux.user_version = 3;
1066 PRAGMA aux.user_version;
1071 PRAGMA main.user_version;
1080 PRAGMA aux.user_version = 10;
1081 PRAGMA user_version = 11;
1086 PRAGMA aux.user_version;
1091 PRAGMA main.user_version;
1097 PRAGMA aux.user_version;
1102 PRAGMA main.user_version;
1110 PRAGMA user_version = -450;
1115 PRAGMA user_version;
1125 PRAGMA temp.cache_size = 1;
1138 db eval {PRAGMA database_list} {
1154 PRAGMA application_id;
1158 execsql {PRAGMA Application_ID(12345); PRAGMA application_id;}
1168 PRAGMA temp_store;
1185 PRAGMA temp_store=file;
1186 PRAGMA temp_store;
1204 PRAGMA temp_store=memory;
1205 PRAGMA temp_store;
1221 PRAGMA temp_store_directory;
1228 PRAGMA temp_store_directory='$pwd';
1233 PRAGMA temp_store_directory;
1238 PRAGMA temp_store_directory='/NON/EXISTENT/PATH/FOOBAR';
1243 PRAGMA temp_store_directory='';
1250 PRAGMA temp_store_directory;
1251 PRAGMA temp_store=FILE;
1259 PRAGMA temp_store_directory='$pwd';
1268 PRAGMA temp_store = 0;
1269 PRAGMA temp_store;
1274 PRAGMA temp_store = 1;
1275 PRAGMA temp_store;
1280 PRAGMA temp_store = 2;
1281 PRAGMA temp_store;
1286 PRAGMA temp_store = 3;
1287 PRAGMA temp_store;
1295 PRAGMA temp_store = 1;
1330 PRAGMA count_changes = 1;
1392 PRAGMA temp.table_info('abc');
1400 PRAGMA temp.default_cache_size = 200;
1401 PRAGMA temp.default_cache_size;
1409 PRAGMA temp.cache_size = 400;
1410 PRAGMA temp.cache_size;
1421 PRAGMA vdbe_trace=on;
1422 PRAGMA vdbe_listing=on;
1423 PRAGMA sql_trace=on;
1434 PRAGMA vdbe_trace=off;
1435 PRAGMA vdbe_listing=off;
1436 PRAGMA sql_trace=off;
1447 # EVIDENCE-OF: R-15672-33611 PRAGMA schema.page_count; Return the total
1458 PRAGMA page_count;
1459 PRAGMA main.page_count;
1460 PRAGMA temp.page_count;
1471 PRAGMA page_count;
1486 PRAGMA page_count;
1494 PRAGMA auto_vacuum = 0;
1503 PRAGMA aux.page_count;
1519 PRAGMA cache_size=59;
1520 PRAGMA cache_size;
1536 execsql { PRAGMA cache_size }
1542 dbX eval {PRAGMA temp_store_directory = ""}
1561 PRAGMA lock_proxy_file="mylittleproxy";
1565 PRAGMA lock_proxy_file;
1572 PRAGMA lock_proxy_file="mylittleproxy";
1580 PRAGMA lock_proxy_file=":auto:";
1584 PRAGMA lock_proxy_file;
1592 PRAGMA lock_proxy_file="myotherproxy";
1604 PRAGMA lock_proxy_file="myoriginalproxy";
1605 PRAGMA lock_proxy_file="myotherproxy";
1606 PRAGMA lock_proxy_file;
1615 PRAGMA lock_proxy_file=":auto:";
1616 PRAGMA lock_proxy_file;
1624 PRAGMA lock_proxy_file=":auto:";
1625 PRAGMA lock_proxy_file;
1635 PRAGMA lock_proxy_file=":auto:";
1652 PRAGMA lock_proxy_file="yetanotherproxy";
1653 PRAGMA lock_proxy_file;
1666 PRAGMA lock_proxy_file=":auto:";
1667 PRAGMA lock_proxy_file;
1698 PRAGMA auto_vacuum=$::autovac_setting;
1699 PRAGMA auto_vacuum;
1723 PRAGMA temp_store=$::temp_setting;
1724 PRAGMA temp_store=$::temp_setting;
1725 PRAGMA temp_store;
1736 catchsql {PRAGMA error}
1739 catchsql {PRAGMA error='This is the error message'}
1742 catchsql {PRAGMA error='7 This is the error message'}
1745 catchsql {PRAGMA error=7}
1748 file tail [lindex [execsql {PRAGMA filename}] 0]
1758 catchsql {PRAGMA data_store_directory}
1762 catchsql "PRAGMA data_store_directory='$pwd';"
1765 catchsql {PRAGMA data_store_directory}
1770 catchsql "PRAGMA data_store_directory='$pwd';"
1774 catchsql "PRAGMA database_list;" db2
1780 catchsql "PRAGMA database_list;" db2
1785 catchsql "PRAGMA data_store_directory='';"
1788 catchsql {PRAGMA data_store_directory}
1804 PRAGMA page_size = 1024;
1805 PRAGMA auto_vacuum = 0;
1830 execsql { PRAGMA integrity_check }
1838 PRAGMA integrity_check;
1842 execsql { PRAGMA main.integrity_check; }
1845 execsql { PRAGMA aux.integrity_check; }
1853 PRAGMA integrity_check;
1857 execsql { PRAGMA main.integrity_check; }
1860 execsql { PRAGMA aux.integrity_check; }
1884 capture_pragma db2 out {PRAGMA index_info(i2)}
1888 # EVIDENCE-OF: R-56143-29319 PRAGMA schema.index_xinfo(index-name); This
1896 capture_pragma db2 out {PRAGMA index_xinfo(i2)}
1900 # (The first column of output from PRAGMA index_xinfo is...)
1904 # (The second column of output from PRAGMA index_xinfo is...)
1909 # (The third column of output from PRAGMA index_xinfo is...)
1914 # (The fourth column of output from PRAGMA index_xinfo is...)
1918 # (The fifth column of output from PRAGMA index_xinfo is...)
1922 # (The sixth column of output from PRAGMA index_xinfo is...)
1927 db2 eval {PRAGMA index_xinfo(i2)}
1930 db2 eval {PRAGMA index_xinfo(i2x)}
1933 db2 eval {PRAGMA index_xinfo(i3)}
1936 # EVIDENCE-OF: R-64103-17776 PRAGMA schema.index_list(table-name); This
1939 # (The first column of output from PRAGMA index_list is...)
1943 # (The second column of output from PRAGMA index_list is...)
1946 # (The third column of output from PRAGMA index_list is...)
1949 # (The fourth column of output from PRAGMA index_list is...)
1959 capture_pragma db2 out {PRAGMA index_list(t1)}
1968 PRAGMA table_info(t1);
1978 PRAGMA foreign_key_list(t2);
1986 PRAGMA page_size = 1024;
1990 PRAGMA integrity_check;
2002 PRAGMA integrity_check;