Lines Matching refs:PRAGMA
13 # "PRAGMA journal_mode=WAL" mode.
21 # "PRAGMA journal_mode=WAL" treats "WAL" as an unrecognized mode.
26 execsql { PRAGMA journal_mode = wal }
29 execsql { PRAGMA main.journal_mode = wal }
32 execsql { PRAGMA main.journal_mode }
41 execsql { PRAGMA page_size = 1024 }
42 execsql { PRAGMA journal_mode = wal }
91 # If the first statement executed is "PRAGMA journal_mode = wal", and
99 execsql { PRAGMA journal_mode = wal }
109 execsql { PRAGMA journal_mode = persist }
136 execsql { PRAGMA main.journal_mode } db2
139 execsql { PRAGMA main.journal_mode = wal } db
145 catchsql { PRAGMA journal_mode = delete } db
148 execsql { PRAGMA main.journal_mode } db
153 execsql { PRAGMA journal_mode = delete } db
156 execsql { PRAGMA main.journal_mode } db
169 do_test walmode-4.16 { execsql { PRAGMA main.journal_mode } db } {delete}
170 do_test walmode-4.17 { execsql { PRAGMA main.journal_mode } db2 } {delete}
173 catchsql { PRAGMA main.journal_mode = wal } db
176 execsql { PRAGMA main.journal_mode } db
190 execsql { PRAGMA main.journal_mode }
193 execsql { PRAGMA main.journal_mode = wal }
202 PRAGMA main.journal_mode;
206 execsql { PRAGMA main.journal_mode = wal }
212 PRAGMA main.journal_mode;
223 execsql { PRAGMA main.journal_mode }
226 execsql { PRAGMA main.journal_mode = wal }
235 PRAGMA main.journal_mode;
239 execsql { PRAGMA main.journal_mode = wal }
245 PRAGMA main.journal_mode;
251 execsql { PRAGMA temp.journal_mode }
254 execsql { PRAGMA temp.journal_mode = wal }
263 PRAGMA temp.journal_mode;
267 execsql { PRAGMA temp.journal_mode = wal }
273 PRAGMA temp.journal_mode;
291 PRAGMA journal_mode = $mode;
292 PRAGMA journal_mode = wal;
299 # Test the effect of a "PRAGMA journal_mode" command being the first
307 PRAGMA journal_mode = WAL;
312 1 "PRAGMA journal_mode" wal
313 2 "PRAGMA main.journal_mode" wal
314 3 "PRAGMA journal_mode = delete" delete
315 4 "PRAGMA journal_mode" delete
316 5 "PRAGMA main.journal_mode" delete
317 6 "PRAGMA journal_mode = wal" wal
318 7 "PRAGMA journal_mode" wal
319 8 "PRAGMA main.journal_mode" wal
321 9 "PRAGMA journal_mode" wal
322 10 "PRAGMA main.journal_mode" wal
323 11 "PRAGMA main.journal_mode = delete" delete
324 12 "PRAGMA journal_mode" delete
325 13 "PRAGMA main.journal_mode" delete
326 14 "PRAGMA main.journal_mode = wal" wal
327 15 "PRAGMA journal_mode" wal
328 16 "PRAGMA main.journal_mode" wal
339 # Test the effect of a "PRAGMA journal_mode" command on an attached
345 PRAGMA journal_mode = WAL;
349 do_execsql_test walmode-8.2 { PRAGMA main.journal_mode } {wal}
350 do_execsql_test walmode-8.3 { PRAGMA two.journal_mode } {delete}
351 do_execsql_test walmode-8.4 { PRAGMA two.journal_mode = DELETE } {delete}
356 do_execsql_test walmode-8.6 { PRAGMA main.journal_mode } {wal}
357 do_execsql_test walmode-8.7 { PRAGMA two.journal_mode } {delete}
359 do_execsql_test walmode-8.9 { PRAGMA two.journal_mode } {delete}
361 do_execsql_test walmode-8.11 { PRAGMA main.journal_mode } {wal}
362 do_execsql_test walmode-8.12 { PRAGMA journal_mode } {wal}
368 PRAGMA two.journal_mode=WAL;
369 PRAGMA two.journal_mode;
375 do_execsql_test walmode-8.13 { PRAGMA journal_mode = WAL } {wal}
377 do_execsql_test walmode-8.15 { PRAGMA main.journal_mode } {wal}
378 do_execsql_test walmode-8.16 { PRAGMA two.journal_mode } {wal}
380 do_execsql_test walmode-8.18 { PRAGMA two.journal_mode } {wal}
383 do_test walmode-8.19 { execsql { PRAGMA main.journal_mode } db2 } {wal}
386 do_execsql_test walmode-8.20 { PRAGMA journal_mode = DELETE } {delete}
387 do_execsql_test walmode-8.21 { PRAGMA main.journal_mode } {delete}
388 do_execsql_test walmode-8.22 { PRAGMA two.journal_mode } {delete}
389 do_execsql_test walmode-8.21 { PRAGMA journal_mode = WAL } {wal}
390 do_execsql_test walmode-8.21 { PRAGMA main.journal_mode } {wal}
391 do_execsql_test walmode-8.22 { PRAGMA two.journal_mode } {wal}