Lines Matching refs:f2
25 set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
40 execsql {CREATE TABLE test1(f1 int,f2 int)}
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}
73 execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
79 execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
85 # Swap the values of f1 and f2 for all elements
88 execsql {UPDATE test1 SET F2=f1, F1=f2}
95 execsql {UPDATE test1 SET F2=f1, F1=f2}
107 INSERT INTO test1(f1,f2) VALUES(8,88);
108 INSERT INTO test1(f1,f2) VALUES(8,888);
109 INSERT INTO test1(f1,f2) VALUES(77,128);
110 INSERT INTO test1(f1,f2) VALUES(777,128);
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}
137 UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
143 SELECT * FROM test1 ORDER BY f1,f2
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}
199 UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
205 SELECT * FROM test1 ORDER BY f1,f2
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}
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}
331 # explain {UPDATE test1 SET f2=f2-1 WHERE f1==8 and F2<300}
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}