Lines Matching refs:PRAGMA

13 # This file implements tests for PRAGMA data_version command.
25   PRAGMA data_version;
28   PRAGMA temp.data_version;
33   PRAGMA main.data_version=1234;
34   PRAGMA main.data_version;
37 # EVIDENCE-OF: R-27726-60934 The "PRAGMA data_version" command provides
40 # EVIDENCE-OF: R-47505-58569 The "PRAGMA data_version" value is
44   PRAGMA data_version;
46   PRAGMA data_version;
49   PRAGMA data_version;
52   PRAGMA data_version;
59     PRAGMA data_version;
64   PRAGMA data_version;
66   PRAGMA data_version;
68   PRAGMA data_version;
71   PRAGMA data_version;
72   PRAGMA shrink_memory;
76 # invocations of "PRAGMA data_version" from the same connection will be
85     PRAGMA data_version;
87     PRAGMA data_version;
91     PRAGMA data_version;
96   PRAGMA data_version;
103     PRAGMA data_version;
105     PRAGMA data_version;
107     PRAGMA data_version;
112     PRAGMA data_version;
118     PRAGMA data_version;
123     PRAGMA data_version;
127 # EVIDENCE-OF: R-19326-44825 The "PRAGMA data_version" value is a local
129 # concurrent invocations of "PRAGMA data_version" on separate database
134   expr {[db eval {PRAGMA data_version}]!=[db2 eval {PRAGMA data_version}]}
137 # EVIDENCE-OF: R-54562-06892 The behavior of "PRAGMA data_version" is
144   db eval {PRAGMA data_version; SELECT * FROM t1;}
158     PRAGMA data_version;
165 # EVIDENCE-OF: R-54562-06892 The behavior of "PRAGMA data_version" is
177       PRAGMA data_version;
182       PRAGMA data_version;
184       PRAGMA data_version;
189       PRAGMA data_version;
193       PRAGMA data_version;
200       PRAGMA data_version;
207       PRAGMA data_version;
213       PRAGMA data_version;
232   db eval {PRAGMA journal_mode=WAL}
236       PRAGMA data_version;
237       PRAGMA journal_mode;
243       PRAGMA data_version;
244       PRAGMA journal_mode;
249     db eval {UPDATE t1 SET a=111*(a/100); PRAGMA data_version; SELECT * FROM t1}
252     db2 eval {PRAGMA data_version; SELECT * FROM t1;}
259 # Check that empty write transactions do not cause the return of "PRAGMA
267     PRAGMA journal_mode = PERSIST;
268     PRAGMA locking_mode = EXCLUSIVE;
277     PRAGMA data_version;
283     PRAGMA data_version;