update.test - OpenGrok cross reference for /titanic_44/usr/src/lib/libsqlite/test/update.test

Lines Matching refs:execsql
25   set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
33        {execsql {UPDATE sqlite_master SET name='xyz' WHERE name='123'}} msg]
40   execsql {CREATE TABLE test1(f1 int,f2 int)}
43     execsql $sql
45   execsql {SELECT * FROM test1 ORDER BY f1}
51   set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
55   set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
59   set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
66   execsql {UPDATE test1 SET f2=f2*3}
69   execsql {SELECT * FROM test1 ORDER BY f1}
72   execsql {PRAGMA count_changes=on}
73   execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
76   execsql {SELECT * FROM test1 ORDER BY f1}
79   execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
82   execsql {SELECT * FROM test1 ORDER BY f1}
88   execsql {UPDATE test1 SET F2=f1, F1=f2}
91   execsql {SELECT * FROM test1 ORDER BY F1}
94   execsql {PRAGMA count_changes=off}
95   execsql {UPDATE test1 SET F2=f1, F1=f2}
98   execsql {SELECT * FROM test1 ORDER BY F1}
105   execsql {
112   execsql {SELECT * FROM test1 ORDER BY f1,f2}
115   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
116   execsql {SELECT * FROM test1 ORDER BY f1,f2}
119   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
120   execsql {SELECT * FROM test1 ORDER BY f1,f2}
123   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
124   execsql {SELECT * FROM test1 ORDER BY f1,f2}
127   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
128   execsql {SELECT * FROM test1 ORDER BY f1,f2}
131   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
132   execsql {SELECT * FROM test1 ORDER BY f1,f2}
135   execsql {
141   execsql {
150   execsql {CREATE INDEX idx1 ON test1(f1)}
151   execsql {SELECT * FROM test1 ORDER BY f1,f2}
154   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
155   execsql {SELECT * FROM test1 ORDER BY f1,f2}
158   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
159   execsql {SELECT * FROM test1 ORDER BY f1,f2}
162   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
163   execsql {SELECT * FROM test1 ORDER BY f1,f2}
166   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
167   execsql {SELECT * FROM test1 ORDER BY f1,f2}
170   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
173   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
176   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
179   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
182   execsql {SELECT * FROM test1 ORDER BY f1,f2}
185   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
188   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
191   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
194   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
197   execsql {
203   execsql {
209   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
212   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
215   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
218   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
223 execsql {PRAGMA synchronous=FULL}
225   execsql {DROP INDEX idx1}
226   execsql {CREATE INDEX idx1 ON test1(f2)}
227   execsql {SELECT * FROM test1 ORDER BY f1,f2}
230   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
231   execsql {SELECT * FROM test1 ORDER BY f1,f2}
234   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
237   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
240   execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
243   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
244   execsql {SELECT * FROM test1 ORDER BY f1,f2}
247   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
248   execsql {SELECT * FROM test1 ORDER BY f1,f2}
251   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
254   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
257   execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
260   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
261   execsql {SELECT * FROM test1 ORDER BY f1,f2}
264   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
267   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
270   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
273   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
274   execsql {SELECT * FROM test1 ORDER BY f1,f2}
277   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
280   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
283   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
286   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
289   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
290   execsql {SELECT * FROM test1 ORDER BY f1,f2}
293   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
296   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
299   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
302   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
309   execsql {CREATE INDEX idx2 ON test1(f2)}
310   execsql {CREATE INDEX idx3 ON test1(f1,f2)}
311   execsql {SELECT * FROM test1 ORDER BY f1,f2}
314   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
315   execsql {SELECT * FROM test1 ORDER BY f1,f2}
318   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
321   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
324   execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
327   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
328   execsql {SELECT * FROM test1 ORDER BY f1,f2}
332   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
333   execsql {SELECT * FROM test1 ORDER BY f1,f2}
336   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
339   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
342   execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
345   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
346   execsql {SELECT * FROM test1 ORDER BY f1,f2}
349   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
352   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
355   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
358   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
359   execsql {SELECT * FROM test1 ORDER BY f1,f2}
362   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
365   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
368   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
371   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
374   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
375   execsql {SELECT * FROM test1 ORDER BY f1,f2}
378   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
381   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
384   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
387   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
393   set v [catch {execsql {
399   set v [catch {execsql {
405   set v [catch {execsql {
411   set v [catch {execsql {
421   execsql {
490   execsql {
496   execsql {
508   execsql {
528   execsql {
533   execsql {
539   execsql {
546   execsql {
556   execsql {