Home
last modified time | relevance | path

Searched refs:UPDATE (Results 1 – 25 of 43) sorted by relevance

12

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dupdate.test64 execsql {UPDATE test1 SET f2=f2*3}
86 execsql {UPDATE test1 SET F2=f1, F1=f2}
93 execsql {UPDATE test1 SET F2=f1, F1=f2}
435 UPDATE t1 SET a=1, e=9 WHERE f=6;
441 UPDATE t1 SET a=1, e=10 WHERE f=7;
452 UPDATE t1 SET b=2, e=11 WHERE f=6;
458 UPDATE t1 SET b=2, e=12 WHERE f=7;
532 UPDATE t2 SET rowid=rowid-1;
538 UPDATE t2 SET rowid=rowid+10000;
539 UPDATE t2 SET rowid=rowid-9999;
[all …]
H A Dbigrow.test136 UPDATE t1 SET b=b||b;
137 UPDATE t1 SET b=b||b;
138 UPDATE t1 SET b=b||b;
160 UPDATE t1 SET b=b||b;
161 UPDATE t1 SET b=b||b;
162 UPDATE t1 SET b=b||b;
163 UPDATE t1 SET b=b||b;
164 UPDATE t1 SET b=b||b;
165 UPDATE t1 SET b=b||b;
166 UPDATE t1 SET b=b||b;
[all …]
H A Dconflict.test375 UPDATE t3 SET x=0;
534 UPDATE t2 SET a=a+1 WHERE a=1;
546 UPDATE t2 SET b=b+1 WHERE b=1;
553 UPDATE t3 SET x=x+1;
565 UPDATE t3 SET x=x+1;
566 UPDATE t2 SET b=b+1 WHERE b=1;
589 UPDATE t3 SET x=x+1;
601 UPDATE t3 SET x=x+1;
625 UPDATE t3 SET x=x+1;
637 UPDATE t3 SET x=x+1;
[all …]
H A Dmemdb.test224 # cmd An UPDATE command to execute against table t1
230 1 {} {} UPDATE 1 {6 7 8 9} 1
231 2 REPLACE {} UPDATE 0 {7 6 9} 1
232 3 IGNORE {} UPDATE 0 {6 7 3 9} 1
233 4 FAIL {} UPDATE 1 {6 7 3 4} 1
234 5 ABORT {} UPDATE 1 {1 2 3 4} 1
235 6 ROLLBACK {} UPDATE 1 {1 2 3 4} 0
236 7 REPLACE {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
237 8 IGNORE {} {UPDATE OR REPLACE} 0 {7 6 9} 1
238 9 FAIL {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
[all …]
H A Dtrigger2.test30 # trigger2-3.1: UPDATE OF triggers
46 # trigger2-6.2[a-f]: UPDATE statements
201 {UPDATE tbl SET b = old.b;}
205 UPDATE tbl SET c = old.c;
322 # trigger2-3.1: UPDATE OF triggers
331 UPDATE log SET a = a + 1;
337 UPDATE tbl SET b = 10; -- 0
339 UPDATE tbl SET a = 4, b = 10; --0
368 UPDATE log SET a = 0;
372 UPDATE log SET a = 0;
[all …]
H A Dmain.test92 UPDATE pqr;
99 UPDATE pqr;
126 UPDATE pqr;
139 UPDATE pqr SET a=5;
146 UPDATE pqr SET a=5;
152 UPDATE pqr SET a=5;
159 UPDATE pqr SET a=5;
166 UPDATE pqr SET a=5;
173 UPDATE pqr SET a=5;
179 UPDATE pqr SET a=5;
[all …]
H A Dnotnull.test185 UPDATE t1 SET a=null;
193 UPDATE OR REPLACE t1 SET a=null;
201 UPDATE OR IGNORE t1 SET a=null;
209 UPDATE OR ABORT t1 SET a=null;
217 UPDATE t1 SET b=null;
241 UPDATE t1 SET c=null, d=e, e=d;
249 UPDATE t1 SET d=null, a=b, b=a;
257 UPDATE t1 SET e=null, a=b, b=a;
424 UPDATE t1 SET a=null;
448 UPDATE OR ABORT t1 SET a=null;
[all …]
H A Dmisc3.test30 UPDATE t1 SET b=b||b;
31 UPDATE t1 SET b=b||b;
32 UPDATE t1 SET b=b||b;
33 UPDATE t1 SET b=b||b;
34 UPDATE t1 SET b=b||b;
36 UPDATE t1 SET b=substr(b,1,500);
39 catchsql {UPDATE t1 SET a=CASE a WHEN 2 THEN 1 ELSE a END, b='y';}
64 catchsql {UPDATE t1 SET a=CASE a WHEN 128 THEN 127 ELSE a END, b='';}
H A Dtrigger3.test92 # Check that we can also do RAISE(IGNORE) for UPDATE and DELETE
98 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
108 UPDATE tbl SET c = 10;
123 UPDATE tbl SET c = 10;
H A Dlock.test56 execsql {UPDATE t1 SET a=b, b=a} db2
102 # You cannot UPDATE a table from within the callback of a SELECT
107 set r [catch {db eval {UPDATE t1 SET a=b, b=a}} msg]
113 # But you can UPDATE a different table from the one that is used in
118 set r [catch {db eval {UPDATE t2 SET x=y, y=x}} msg]
327 UPDATE t1 SET a=tx_exec('SELECT x FROM t2');
337 UPDATE t3 SET x=tx_exec('SELECT x FROM t2');
H A Dversion.test104 UPDATE cnt SET ins=ins+1 WHERE name='t1';
107 UPDATE cnt SET del=del+1 WHERE name='t1';
110 UPDATE cnt SET ins=ins+1 WHERE name='t2';
113 UPDATE cnt SET del=del+1 WHERE name='t2';
H A Dmisc1.test133 UPDATE t2 SET a=a||a||a||a;
146 # before executing a command. Thus if "WHERE" is misspelled on an UPDATE,
154 UPDATE t3 SET a=0 WHEREwww b=2;
300 catchsql "UPDATE manycol SET x1=x1+1 $::where"
306 catchsql "UPDATE manycol SET x1=x1+1 $::where AND rowid>0"
529 CREATE TEMP TRIGGER trigTest_1 AFTER UPDATE ON TempTable BEGIN
535 UPDATE TempTable SET TestString = TestString + 1 WHERE TestID IN (1, 2);
H A Dattach.test211 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
219 UPDATE t2 SET x=x+10;
236 UPDATE db2.t2 SET x=x+10;
336 UPDATE t2 SET x=x+1 WHERE x=50;
359 catchsql {UPDATE t1 SET a=a+1}
365 catchsql {UPDATE t2 SET x=x+1 WHERE x=50}
H A Dcapi2.test340 catchsql {UPDATE t3 SET x=x+1}
353 catchsql {UPDATE t1 SET b=b+1}
411 UPDATE t1 SET a=a+10;
422 UPDATE t1 SET a=a+10;
446 UPDATE t1 SET a=a-20;
H A Dmalloc.test91 UPDATE t1 SET b=b||b||b||b;
92 UPDATE t1 SET b=a WHERE a in (10,12,22);
171 UPDATE t1 SET b=a WHERE a in (10,12,22);
H A Drowid.test101 UPDATE t1 SET rowid=12345 WHERE x==1;
113 UPDATE t1 SET oid=12346 WHERE x==1;
125 UPDATE t1 SET _rowid_=12347 WHERE x==1;
130 # But we can use ROWID in the WHERE clause of an UPDATE that does not
135 set sql "UPDATE t1 SET x=2 WHERE OID==$x2rowid(3)"
141 set sql "UPDATE t1 SET x=3 WHERE _rowid_==$x2rowid(3)"
H A Dfkey1.test30 FOREIGN KEY (b,c) REFERENCES t2(x,y) ON UPDATE CASCADE
H A Dintpkey.test115 UPDATE t1 SET a=4 WHERE b='one';
192 UPDATE t1 SET a=8 WHERE b=='y';
234 UPDATE t1 SET a=-4 WHERE rowid=8;
443 UPDATE t1 SET c='www' WHERE c='world';
H A Dtrigger1.test36 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
43 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
112 CREATE TRIGGER temp_trig UPDATE ON temp_table BEGIN
121 CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
H A Dquote.test68 execsql {UPDATE '@abc' SET '#xyz'=11}
H A Dauth.test338 catchsql {UPDATE t2 SET a=11}
350 catchsql {UPDATE t2 SET b=22, c=33}
362 catchsql {UPDATE t2 SET b=22, c=33}
1802 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
1805 UPDATE t2 SET a=a+1;
1818 UPDATE t2 SET a=a+100;
1832 UPDATE t2 SET a=a+1;
1849 CREATE TRIGGER r2 INSTEAD OF UPDATE ON v1 BEGIN
1858 UPDATE v1 SET x=1 WHERE x=117
H A Din.test122 # Make sure the UPDATE and DELETE commands work with IN-SELECT
126 UPDATE t1 SET b=b*2
/illumos-gate/usr/src/contrib/ast/src/cmd/ksh93/edit/
H A Demacs.c392 draw(ep,UPDATE); in ed_emacsread()
522 draw(ep,UPDATE); in ed_emacsread()
583 draw(ep,UPDATE); in ed_emacsread()
699 draw(ep,UPDATE); in ed_emacsread()
707 draw(ep,UPDATE); in ed_emacsread()
758 draw(ep,UPDATE); in show_info()
765 draw(ep,UPDATE); in show_info()
965 draw(ep,UPDATE); in escape()
1062 draw(ep,UPDATE); in escape()
1133 draw(ep,UPDATE); in escape()
[all …]
/illumos-gate/usr/src/lib/librstp/common/
H A Dportinfo.c33 CHOOSE(UPDATE), \
371 case UPDATE: in STP_info_enter_state()
463 return STP_hop_2_state (this, UPDATE); in STP_info_check_conditions()
466 case UPDATE: in STP_info_check_conditions()
470 return STP_hop_2_state (this, UPDATE); in STP_info_check_conditions()
/illumos-gate/usr/src/cmd/print/scripts/
H A Dppdmgr1450 UPDATE=update
1515 action=${UPDATE}
1749 "${REBUILD}" | "${UPDATE}")

12