update.test - OpenGrok cross reference for /sqlite-3.40.0/test/update.test

Lines Matching refs:execsql
22   set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
30        {execsql {UPDATE sqlite_master SET name='xyz' WHERE name='123'}} msg]
37   execsql {CREATE TABLE test1(f1 int,f2 int)}
40     execsql $sql
42   execsql {SELECT * FROM test1 ORDER BY f1}
48   set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
52   set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
56   set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
63   execsql {UPDATE test1 SET f2=f2*3}
78   execsql {SELECT * FROM test1 ORDER BY f1}
81   execsql {PRAGMA count_changes=on}
82   execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
85   execsql {SELECT * FROM test1 ORDER BY f1}
88   execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
91   execsql {SELECT * FROM test1 ORDER BY f1}
97   execsql {UPDATE test1 SET F2=f1, F1=f2}
100   execsql {SELECT * FROM test1 ORDER BY F1}
103   execsql {PRAGMA count_changes=off}
104   execsql {UPDATE test1 SET F2=f1, F1=f2}
107   execsql {SELECT * FROM test1 ORDER BY F1}
114   execsql {
121   execsql {SELECT * FROM test1 ORDER BY f1,f2}
124   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
125   execsql {SELECT * FROM test1 ORDER BY f1,f2}
128   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
129   execsql {SELECT * FROM test1 ORDER BY f1,f2}
132   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
133   execsql {SELECT * FROM test1 ORDER BY f1,f2}
136   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
137   execsql {SELECT * FROM test1 ORDER BY f1,f2}
140   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
141   execsql {SELECT * FROM test1 ORDER BY f1,f2}
144   execsql {
150   execsql {
159   execsql {CREATE INDEX idx1 ON test1(f1)}
160   execsql {SELECT * FROM test1 ORDER BY f1,f2}
163   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
164   execsql {SELECT * FROM test1 ORDER BY f1,f2}
167   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
168   execsql {SELECT * FROM test1 ORDER BY f1,f2}
171   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
172   execsql {SELECT * FROM test1 ORDER BY f1,f2}
175   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
176   execsql {SELECT * FROM test1 ORDER BY f1,f2}
179   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
182   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
185   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
188   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
191   execsql {SELECT * FROM test1 ORDER BY f1,f2}
194   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
197   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
200   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
203   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
206   execsql {
212   execsql {
218   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
221   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
224   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
227   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
232 execsql {PRAGMA synchronous=FULL}
234   execsql {DROP INDEX idx1}
235   execsql {CREATE INDEX idx1 ON test1(f2)}
236   execsql {SELECT * FROM test1 ORDER BY f1,f2}
239   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
240   execsql {SELECT * FROM test1 ORDER BY f1,f2}
243   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
246   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
249   execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
252   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
253   execsql {SELECT * FROM test1 ORDER BY f1,f2}
256   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
257   execsql {SELECT * FROM test1 ORDER BY f1,f2}
260   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
263   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
266   execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
269   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
270   execsql {SELECT * FROM test1 ORDER BY f1,f2}
273   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
276   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
279   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
282   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
283   execsql {SELECT * FROM test1 ORDER BY f1,f2}
286   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
289   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
292   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
295   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
298   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
299   execsql {SELECT * FROM test1 ORDER BY f1,f2}
302   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
305   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
308   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
311   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
318   execsql {CREATE INDEX idx2 ON test1(f2)}
319   execsql {CREATE INDEX idx3 ON test1(f1,f2)}
320   execsql {SELECT * FROM test1 ORDER BY f1,f2}
323   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
324   execsql {SELECT * FROM test1 ORDER BY f1,f2}
327   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
330   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
333   execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
336   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
337   execsql {SELECT * FROM test1 ORDER BY f1,f2}
341   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
342   execsql {SELECT * FROM test1 ORDER BY f1,f2}
345   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
348   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
351   execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
354   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
355   execsql {SELECT * FROM test1 ORDER BY f1,f2}
358   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
361   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
364   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
367   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
368   execsql {SELECT * FROM test1 ORDER BY f1,f2}
371   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
374   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
377   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
380   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
383   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
384   execsql {SELECT * FROM test1 ORDER BY f1,f2}
387   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
390   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
393   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
396   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
402   set v [catch {execsql {
408   set v [catch {execsql {
414   set v [catch {execsql {
420   set v [catch {execsql {
430   execsql {
500     execsql {
506     execsql {
512     execsql {
518     execsql {
531   execsql {
551   execsql {
556   execsql {
562   execsql {
569   execsql {
579   execsql {
591   execsql {
604   execsql {