Lines Matching refs:UPDATE

15 # focus of this file is testing the UPDATE statement.
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]
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}
88   execsql {UPDATE test1 SET F2=f1, F1=f2}
95   execsql {UPDATE test1 SET F2=f1, F1=f2}
115   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
119   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
123   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
127   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
131   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
137     UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
154   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
158   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
162   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
166   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
179   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
199     UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128;
230   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
243   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
247   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
260   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
273   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
289   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
314   execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
327   execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
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}
345   execsql {UPDATE test1 SET f1=f1+1 WHERE f2==128}
358   execsql {UPDATE test1 SET f1=f1-1 WHERE f1>100 and f2==128}
374   execsql {UPDATE test1 SET f1=f1-1 WHERE f1<=100 and f2==128}
394     UPDATE test1 SET x=11 WHERE f1=1025
400     UPDATE test1 SET f1=x(11) WHERE f1=1025
406     UPDATE test1 SET f1=11 WHERE x=1025
412     UPDATE test1 SET f1=11 WHERE x(f1)=1025
437     UPDATE t1 SET a=1, e=9 WHERE f=6;
443     UPDATE t1 SET a=1, e=10 WHERE f=7;
454     UPDATE t1 SET b=2, e=11 WHERE f=6;
460     UPDATE t1 SET b=2, e=12 WHERE f=7;
471     UPDATE t1 SET c=3, d=4, e=13 WHERE f=6;
477     UPDATE t1 SET c=3, d=4, e=14 WHERE f=7;
491     UPDATE t1 SET e=e+1 WHERE b IN (SELECT b FROM t1);
497     UPDATE t1 SET e=e+1 WHERE a IN (SELECT a FROM t1);
534     UPDATE t2 SET rowid=rowid-1;
540     UPDATE t2 SET rowid=rowid+10000;
541     UPDATE t2 SET rowid=rowid-9999;
557     UPDATE t2 SET rowid=rowid-1;