Home
last modified time | relevance | path

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

12345678910>>...13

/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
290 ON tbl BEGIN $tr_program_fixed END;"
302 ON tbl BEGIN $tr_program_fixed END;"
395 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
399 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
420 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
438 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
460 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
514 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
[all …]
H A Dtrigger1.test53 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
195 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
202 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
216 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
322 CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
[all …]
H A Dindex.test24 execsql {CREATE INDEX index1 ON test1(f1)}
113 execsql {CREATE INDEX index9 ON test1(cnt)}
175 execsql {CREATE INDEX index1 ON test1(f1)}
197 CREATE INDEX index1 ON test1(a);
198 CREATE INDEX index2 ON test1(b);
199 CREATE INDEX index3 ON test1(a,b);
247 execsql {CREATE INDEX idx1 ON tab1(a)}
257 CREATE INDEX i1 ON t1(a);
378 CREATE INDEX t4i1 ON t4(a);
434 CREATE INDEX t6i1 ON t6(a,b);
[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.test255 CREATE INDEX i2 ON t2(x);
384 CREATE UNIQUE INDEX t3i1 ON t3(x);
392 CREATE UNIQUE INDEX t3i1b ON t3(a);
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
518 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
525 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
532 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
539 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
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 );
352 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"}
508 a INTEGER UNIQUE ON CONFLICT IGNORE,
509 b INTEGER UNIQUE ON CONFLICT FAIL,
510 c INTEGER UNIQUE ON CONFLICT REPLACE,
511 d INTEGER UNIQUE ON CONFLICT ABORT,
512 e INTEGER UNIQUE ON CONFLICT ROLLBACK
674 BEGIN ON CONFLICT ROLLBACK;
684 CREATE UNIQUE INDEX t4x ON t4(x);
[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);
/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);
H A Dgen.h44 #define ON 1 macro
/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>>...13