Lines Matching refs:f2

22   set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
37   execsql {CREATE TABLE test1(f1 int,f2 int)}
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}
82   execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
88   execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
94 # Swap the values of f1 and f2 for all elements
97   execsql {UPDATE test1 SET F2=f1, F1=f2}
104   execsql {UPDATE test1 SET F2=f1, F1=f2}
116     INSERT INTO test1(f1,f2) VALUES(8,88);
117     INSERT INTO test1(f1,f2) VALUES(8,888);
118     INSERT INTO test1(f1,f2) VALUES(77,128);
119     INSERT INTO test1(f1,f2) VALUES(777,128);
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}
146     UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
152     SELECT * FROM test1 ORDER BY f1,f2
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}
208     UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
214     SELECT * FROM test1 ORDER BY f1,f2
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}
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}
340   # explain {UPDATE test1 SET f2=f2-1 WHERE f1==8 and F2<300}
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}