Lines Matching refs:f2
23 set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
38 execsql {CREATE TABLE test1(f1 int,f2 int)}
49 set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
53 set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
57 set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
64 execsql {UPDATE test1 SET f2=f2*3}
71 execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
77 execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
83 # Swap the values of f1 and f2 for all elements
86 execsql {UPDATE test1 SET F2=f1, F1=f2}
93 execsql {UPDATE test1 SET F2=f1, F1=f2}
105 INSERT INTO test1(f1,f2) VALUES(8,88);
106 INSERT INTO test1(f1,f2) VALUES(8,888);
107 INSERT INTO test1(f1,f2) VALUES(77,128);
108 INSERT INTO test1(f1,f2) VALUES(777,128);
110 execsql {SELECT * FROM test1 ORDER BY f1,f2}
113 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
114 execsql {SELECT * FROM test1 ORDER BY f1,f2}
117 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
118 execsql {SELECT * FROM test1 ORDER BY f1,f2}
121 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
122 execsql {SELECT * FROM test1 ORDER BY f1,f2}
125 execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
126 execsql {SELECT * FROM test1 ORDER BY f1,f2}
129 execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
130 execsql {SELECT * FROM test1 ORDER BY f1,f2}
135 UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
141 SELECT * FROM test1 ORDER BY f1,f2
149 execsql {SELECT * FROM test1 ORDER BY f1,f2}
152 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
153 execsql {SELECT * FROM test1 ORDER BY f1,f2}
156 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
157 execsql {SELECT * FROM test1 ORDER BY f1,f2}
160 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
161 execsql {SELECT * FROM test1 ORDER BY f1,f2}
164 execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
165 execsql {SELECT * FROM test1 ORDER BY f1,f2}
168 execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
171 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
174 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
177 execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
180 execsql {SELECT * FROM test1 ORDER BY f1,f2}
183 execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
186 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
189 execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
192 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
197 UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
203 SELECT * FROM test1 ORDER BY f1,f2
207 execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
210 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
213 execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
216 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
224 execsql {CREATE INDEX idx1 ON test1(f2)}
225 execsql {SELECT * FROM test1 ORDER BY f1,f2}
228 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
229 execsql {SELECT * FROM test1 ORDER BY f1,f2}
232 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
235 execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
238 execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
241 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
242 execsql {SELECT * FROM test1 ORDER BY f1,f2}
245 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
246 execsql {SELECT * FROM test1 ORDER BY f1,f2}
249 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
252 execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
255 execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
258 execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
259 execsql {SELECT * FROM test1 ORDER BY f1,f2}
262 execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
265 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
268 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
271 execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
272 execsql {SELECT * FROM test1 ORDER BY f1,f2}
275 execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
278 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
281 execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
284 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
287 execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
288 execsql {SELECT * FROM test1 ORDER BY f1,f2}
291 execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
294 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
297 execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
300 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
307 execsql {CREATE INDEX idx2 ON test1(f2)}
308 execsql {CREATE INDEX idx3 ON test1(f1,f2)}
309 execsql {SELECT * FROM test1 ORDER BY f1,f2}
312 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
313 execsql {SELECT * FROM test1 ORDER BY f1,f2}
316 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
319 execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
322 execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
325 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
326 execsql {SELECT * FROM test1 ORDER BY f1,f2}
329 # explain {UPDATE test1 SET f2=f2-1 WHERE f1==8 and F2<300}
330 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
331 execsql {SELECT * FROM test1 ORDER BY f1,f2}
334 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
337 execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
340 execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
343 execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
344 execsql {SELECT * FROM test1 ORDER BY f1,f2}
347 execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
350 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
353 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
356 execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
357 execsql {SELECT * FROM test1 ORDER BY f1,f2}
360 execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
363 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
366 execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
369 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
372 execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
373 execsql {SELECT * FROM test1 ORDER BY f1,f2}
376 execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
379 execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
382 execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
385 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}