Home
last modified time | relevance | path

Searched refs:ON (Results 1 – 25 of 326) sorted by relevance

12345678910>>...14

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dtrigger2.test17 # trigger2-1.1.*: ON UPDATE trigger execution model.
44 # 6. ON CONFLICT clause handling
62 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
63 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
83 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
91 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
99 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
126 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
134 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
154 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
[all …]
H A Dtrigger1.test36 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
43 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
53 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
59 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
68 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
71 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
79 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
112 CREATE TRIGGER temp_trig UPDATE ON temp_table BEGIN
121 CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
195 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
[all …]
H A Dindex.test24 execsql {CREATE INDEX index1 ON test1(f1)}
30 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
36 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
53 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
62 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
69 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
83 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
113 execsql {CREATE INDEX index9 ON test1(cnt)}
114 execsql {CREATE INDEX indext ON test1(power)}
134 execsql {CREATE INDEX indext ON test1(cnt)}
[all …]
H A Dtrigger3.test22 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
26 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
98 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
102 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
122 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
138 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
H A Dattach.test211 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
255 CREATE INDEX i2 ON t2(x);
384 CREATE UNIQUE INDEX t3i1 ON t3(x);
392 CREATE UNIQUE INDEX t3i1b ON t3(a);
420 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
430 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
487 CREATE TRIGGER r1 AFTER INSERT ON orig.t1 BEGIN;
495 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
503 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
511 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
[all …]
H A Djoin.test170 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
175 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
180 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
186 SELECT * FROM t1 NATURAL JOIN t2 ON t1.a=t2.b;
188 } {1 {a NATURAL join may not have an ON or USING clause}}
193 } {1 {a NATURAL join may not have an ON or USING clause}}
196 SELECT * FROM t1 JOIN t2 ON t1.a=t2.b USING(b);
198 } {1 {cannot have both ON and USING clauses in the same join}}
211 SELECT * FROM t1 JOIN t2 ON t3.a=t2.b;
346 SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
[all …]
H A Dconflict.test62 if {$conf!=""} {set conf "ON CONFLICT $conf"}
120 if {$conf!=""} {set conf "ON CONFLICT $conf"}
178 if {$conf!=""} {set conf "ON CONFLICT $conf"}
235 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
236 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
298 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
299 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
369 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
370 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
508 a INTEGER UNIQUE ON CONFLICT IGNORE,
[all …]
H A Dversion.test97 CREATE INDEX i1 ON t1(x);
103 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
106 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN
109 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
112 CREATE TRIGGER r4 AFTER DELETE ON t2 FOR EACH ROW BEGIN
H A Dfkey1.test27 REFERENCES t1 ON DELETE CASCADE
30 FOREIGN KEY (b,c) REFERENCES t2(x,y) ON UPDATE CASCADE
H A Dnotnull.test26 c NOT NULL ON CONFLICT REPLACE DEFAULT 6,
27 d NOT NULL ON CONFLICT IGNORE DEFAULT 7,
28 e NOT NULL ON CONFLICT ABORT DEFAULT 8
264 CREATE INDEX t1a ON t1(a);
265 CREATE INDEX t1b ON t1(b);
266 CREATE INDEX t1c ON t1(c);
267 CREATE INDEX t1d ON t1(d);
268 CREATE INDEX t1e ON t1(e);
269 CREATE INDEX t1abc ON t1(a,b,c);
H A Dmalloc.test47 CREATE INDEX i1 ON t1(a,b);
88 CREATE INDEX i1 ON t1(a,b);
134 CREATE INDEX i1 ON t1(a,b);
169 CREATE INDEX i1 ON t1(a,b);
206 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
H A Dunique.test90 CREATE UNIQUE INDEX i2 ON t2(a)
126 CREATE UNIQUE INDEX i2 ON t2(a);
131 CREATE INDEX i2 ON t2(a);
H A Dtrans.test303 CREATE INDEX i1 ON t1(a);
321 CREATE INDEX i2a ON t2(a);
322 CREATE INDEX i2b ON t2(b);
359 CREATE INDEX i2x ON t2(x);
360 CREATE INDEX i2y ON t2(y);
550 CREATE INDEX i1 ON t1(b);
580 CREATE INDEX i1 ON t1(c);
618 CREATE INDEX i1 ON t1(b);
648 CREATE INDEX i1 ON t1(c);
763 CREATE INDEX i3a ON t3(x);
H A Dwhere.test35 CREATE INDEX i1w ON t1(w);
36 CREATE INDEX i1xy ON t1(x,y);
37 CREATE INDEX i2p ON t2(p);
38 CREATE INDEX i2r ON t2(r);
39 CREATE INDEX i2qs ON t2(q, s);
377 CREATE INDEX t3a ON t3(a);
378 CREATE INDEX t3bc ON t3(b,c);
379 CREATE INDEX t3acb ON t3(a,c,b);
676 CREATE INDEX i4xy ON t4(x,y);
/illumos-gate/usr/src/cmd/lp/filter/postscript/postcomm/
H A Dpostcomm.c106 # define ON 1 macro
297 debug = ON; in options()
301 ignore = ON; in options()
570 if (status[i].val != laststate || debug == ON) in getstatus()
/illumos-gate/usr/src/cmd/lp/filter/postscript/common/
H A Dmisc.c160 return(ON);
164 return(ON);
/illumos-gate/usr/src/tools/smatch/src/smatch_data/db/
H A Dbuild_early_index.sh29 CREATE INDEX function_type_size_idx ON function_type_size (type);
30 CREATE INDEX function_type_value_idx ON function_type_value (type);
/illumos-gate/usr/src/pkg/
H A DREADME.pkg30 building packages in ON. All package creation in ON is done using
38 repository which contain the deliverables from an ON build.
94 pkgmogrify(1) use in ON.
173 If you did a full build, all ON packages will be updated.
181 Ask IPS to explicitly check if ON can be installed, and
343 The "slim_install" package may depend on ON packages. If it does,
344 you must send a FLAG DAY message for ON users and PIT who test
416 The following actions are required for all packages in ON.
445 global zones, non-global zones, or both. All ON packages are
455 drivers in ON. A "driver" action should be specified for each driver,
/illumos-gate/usr/src/common/ficl/test/
H A Dtester.fr37 ?DUP IF \ IF THERE IS SOMETHING ON STACK
44 DEPTH ?DUP IF \ IF THERE IS SOMETHING ON THE STACK
/illumos-gate/usr/src/boot/efi/include/
H A DREADME29 HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
33 OTHER INFORMATION ON THIS WEB SITE ARE PROVIDED "AS IS" WITH NO
/illumos-gate/usr/src/lib/krb5/plugins/kdb/ldap/libkdb_ldap/
H A Dldap_handle.c72 server_info->server_status = ON;
117 if (ldap_server_info->server_status == ON) {
H A Dkdb_ldap_conn.c247 server_info->server_status = ON;
322 if (server_info->server_status == ON) in krb5_ldap_db_init()
353 if ((server_info->server_status == NOTSET || server_info->server_status == ON)) { in krb5_ldap_db_single_init()
/illumos-gate/usr/src/cmd/lp/filter/postscript/postprint/
H A Dpostprint.c419 debug = ON; in options()
423 ignore = ON; in options()
915 if ( pg >= 0 && in_olist(pg) == ON ) in redirect()
/illumos-gate/usr/src/cmd/lp/filter/postscript/postio/
H A Dpostio.c378 debug = ON; in options()
382 ignore = ON; in options()
935 if (state != laststate || mesgptr != mesg || debug == ON) in getstatus()
1165 ignore = ON; in quit()
/illumos-gate/usr/src/cmd/tail/
H A DTHIRDPARTYLICENSE17 HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
45 HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
73 HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT

12345678910>>...14