Home
last modified time | relevance | path

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

12

/titanic_44/usr/src/lib/libsqlite/test/
H A Dupdate.test15 # 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}
[all …]
H A Dbigrow.test75 UPDATE t1 SET a=b, b=a;
108 UPDATE t1 SET a=b, b=a
114 UPDATE t1 SET a=b, b=a
138 UPDATE t1 SET b=b||b;
139 UPDATE t1 SET b=b||b;
140 UPDATE t1 SET b=b||b;
146 execsql "UPDATE t1 SET b=b||'$i'"
162 UPDATE t1 SET b=b||b;
163 UPDATE t1 SET b=b||b;
164 UPDATE t1 SET b=b||b;
[all …]
H A Dconflict.test336 # cmd An UPDATE command to execute against table t1
342 1 {} {} UPDATE 1 {6 7 8 9} 1
343 2 REPLACE {} UPDATE 0 {7 6 9} 1
344 3 IGNORE {} UPDATE 0 {6 7 3 9} 1
345 4 FAIL {} UPDATE 1 {6 7 3 4} 1
346 5 ABORT {} UPDATE 1 {1 2 3 4} 1
347 6 ROLLBACK {} UPDATE 1 {1 2 3 4} 0
348 7 REPLACE {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
349 8 IGNORE {} {UPDATE OR REPLACE} 0 {7 6 9} 1
350 9 FAIL {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
[all …]
H A Dmemdb.test226 # cmd An UPDATE command to execute against table t1
232 1 {} {} UPDATE 1 {6 7 8 9} 1
233 2 REPLACE {} UPDATE 0 {7 6 9} 1
234 3 IGNORE {} UPDATE 0 {6 7 3 9} 1
235 4 FAIL {} UPDATE 1 {6 7 3 4} 1
236 5 ABORT {} UPDATE 1 {1 2 3 4} 1
237 6 ROLLBACK {} UPDATE 1 {1 2 3 4} 0
238 7 REPLACE {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
239 8 IGNORE {} {UPDATE OR REPLACE} 0 {7 6 9} 1
240 9 FAIL {} {UPDATE OR IGNORE} 0 {6 7 3 9} 1
[all …]
H A Dtrigger2.test19 # trigger2-1.1.*: ON UPDATE trigger execution model.
25 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
29 # This tests that conditional triggers (ie. UPDATE OF triggers and triggers
32 # trigger2-3.1: UPDATE OF triggers
48 # trigger2-6.2[a-f]: UPDATE statements
85 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
93 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
101 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
113 UPDATE tbl SET a = a * 10, b = b * 10;
203 {UPDATE tbl SET b = old.b;}
[all …]
H A Dmain.test83 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
88 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr; END;
94 UPDATE pqr;
101 UPDATE pqr;
128 UPDATE pqr;
134 UPDATE pqr SET a=[;end;];;;
141 UPDATE pqr SET a=5;
148 UPDATE pqr SET a=5;
154 UPDATE pqr SET a=5;
161 UPDATE pqr SET a=5;
[all …]
H A Dnotnull.test187 UPDATE t1 SET a=null;
195 UPDATE OR REPLACE t1 SET a=null;
203 UPDATE OR IGNORE t1 SET a=null;
211 UPDATE OR ABORT t1 SET a=null;
219 UPDATE t1 SET b=null;
227 UPDATE OR REPLACE t1 SET b=null, d=e, e=d;
235 UPDATE OR IGNORE t1 SET b=null, d=e, e=d;
243 UPDATE t1 SET c=null, d=e, e=d;
251 UPDATE t1 SET d=null, a=b, b=a;
259 UPDATE t1 SET e=null, a=b, b=a;
[all …]
H A Dmisc3.test32 UPDATE t1 SET b=b||b;
33 UPDATE t1 SET b=b||b;
34 UPDATE t1 SET b=b||b;
35 UPDATE t1 SET b=b||b;
36 UPDATE t1 SET b=b||b;
38 UPDATE t1 SET b=substr(b,1,500);
41 catchsql {UPDATE t1 SET a=CASE a WHEN 2 THEN 1 ELSE a END, b='y';}
66 catchsql {UPDATE t1 SET a=CASE a WHEN 128 THEN 127 ELSE a END, b='';}
H A Dtrigger3.test94 # Check that we can also do RAISE(IGNORE) for UPDATE and DELETE
100 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
110 UPDATE tbl SET c = 10;
125 UPDATE tbl SET c = 10;
H A Dlock.test58 execsql {UPDATE t1 SET a=b, b=a} db2
104 # You cannot UPDATE a table from within the callback of a SELECT
109 set r [catch {db eval {UPDATE t1 SET a=b, b=a}} msg]
115 # But you can UPDATE a different table from the one that is used in
120 set r [catch {db eval {UPDATE t2 SET x=y, y=x}} msg]
329 UPDATE t1 SET a=tx_exec('SELECT x FROM t2');
339 UPDATE t3 SET x=tx_exec('SELECT x FROM t2');
H A Dversion.test106 UPDATE cnt SET ins=ins+1 WHERE name='t1';
109 UPDATE cnt SET del=del+1 WHERE name='t1';
112 UPDATE cnt SET ins=ins+1 WHERE name='t2';
115 UPDATE cnt SET del=del+1 WHERE name='t2';
H A Dmisc1.test135 UPDATE t2 SET a=a||a||a||a;
148 # before executing a command. Thus if "WHERE" is misspelled on an UPDATE,
156 UPDATE t3 SET a=0 WHEREwww b=2;
302 catchsql "UPDATE manycol SET x1=x1+1 $::where"
308 catchsql "UPDATE manycol SET x1=x1+1 $::where AND rowid>0"
531 CREATE TEMP TRIGGER trigTest_1 AFTER UPDATE ON TempTable BEGIN
537 UPDATE TempTable SET TestString = TestString + 1 WHERE TestID IN (1, 2);
H A Dattach.test213 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
221 UPDATE t2 SET x=x+10;
238 UPDATE db2.t2 SET x=x+10;
338 UPDATE t2 SET x=x+1 WHERE x=50;
361 catchsql {UPDATE t1 SET a=a+1}
367 catchsql {UPDATE t2 SET x=x+1 WHERE x=50}
H A Dcapi2.test342 catchsql {UPDATE t3 SET x=x+1}
355 catchsql {UPDATE t1 SET b=b+1}
413 UPDATE t1 SET a=a+10;
424 UPDATE t1 SET a=a+10;
448 UPDATE t1 SET a=a-20;
H A Dmalloc.test93 UPDATE t1 SET b=b||b||b||b;
94 UPDATE t1 SET b=a WHERE a in (10,12,22);
173 UPDATE t1 SET b=a WHERE a in (10,12,22);
H A Dfkey1.test32 FOREIGN KEY (b,c) REFERENCES t2(x,y) ON UPDATE CASCADE
H A Dintpkey.test117 UPDATE t1 SET a=4 WHERE b='one';
194 UPDATE t1 SET a=8 WHERE b=='y';
236 UPDATE t1 SET a=-4 WHERE rowid=8;
445 UPDATE t1 SET c='www' WHERE c='world';
H A Drowid.test103 UPDATE t1 SET rowid=12345 WHERE x==1;
115 UPDATE t1 SET oid=12346 WHERE x==1;
127 UPDATE t1 SET _rowid_=12347 WHERE x==1;
132 # But we can use ROWID in the WHERE clause of an UPDATE that does not
137 set sql "UPDATE t1 SET x=2 WHERE OID==$x2rowid(3)"
143 set sql "UPDATE t1 SET x=3 WHERE _rowid_==$x2rowid(3)"
H A Dtrigger1.test38 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
45 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
114 CREATE TRIGGER temp_trig UPDATE ON temp_table BEGIN
123 CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
H A Dquote.test70 execsql {UPDATE '@abc' SET '#xyz'=11}
/titanic_44/usr/src/lib/libshell/common/edit/
H A Demacs.c166 UPDATE, /* Update the screen as need be */ enumerator
386 draw(ep,UPDATE); in ed_emacsread()
516 draw(ep,UPDATE); in ed_emacsread()
576 draw(ep,UPDATE); in ed_emacsread()
665 draw(ep,UPDATE); in ed_emacsread()
673 draw(ep,UPDATE); in ed_emacsread()
724 draw(ep,UPDATE); in show_info()
731 draw(ep,UPDATE); in show_info()
818 draw(ep,UPDATE); in escape()
931 draw(ep,UPDATE); in escape()
[all …]
/titanic_44/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()
/titanic_44/usr/src/cmd/avs/rdc/
H A Dsndrsyncd.c62 #define UPDATE "update" macro
751 if ((cfg_put_cstring(cfg, key, UPDATE, strlen(UPDATE)) < 0) || in sync_complete()
1326 if ((cfg_put_cstring(cfg, key, UPDATE, strlen(UPDATE)) < 0) || in group_complete()
1539 if (strcmp(buf, UPDATE) != 0) { in group_start()
/titanic_44/usr/src/cmd/print/scripts/
H A Dppdmgr1450 UPDATE=update
1515 action=${UPDATE}
1749 "${REBUILD}" | "${UPDATE}")
/titanic_44/usr/src/uts/common/zmod/
H A Dinflate.c384 # define UPDATE(check, buf, len) \ macro
387 # define UPDATE(check, buf, len) adler32(check, buf, len) macro
1110 UPDATE(state->check, put - out, out);
1174 UPDATE(state->check, strm->next_out - out, out);

12