Home
last modified time | relevance | path

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

12345678910>>...12

/titanic_50/usr/src/lib/libsqlite/test/
H A Dtrigger2.test19 # trigger2-1.1.*: ON UPDATE trigger execution model.
46 # 6. ON CONFLICT clause handling
64 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
65 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
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
128 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
136 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
156 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
[all …]
H A Dtrigger1.test38 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
45 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
55 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
61 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
70 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
73 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
81 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
114 CREATE TRIGGER temp_trig UPDATE ON temp_table BEGIN
123 CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
197 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
[all …]
H A Dindex.test26 execsql {CREATE INDEX index1 ON test1(f1)}
32 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
38 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
55 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
64 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
71 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
85 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
115 execsql {CREATE INDEX index9 ON test1(cnt)}
116 execsql {CREATE INDEX indext ON test1(power)}
136 execsql {CREATE INDEX indext ON test1(cnt)}
[all …]
H A Dtrigger3.test24 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
28 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
100 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
104 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
124 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
140 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
H A Dattach.test213 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
257 CREATE INDEX i2 ON t2(x);
386 CREATE UNIQUE INDEX t3i1 ON t3(x);
394 CREATE UNIQUE INDEX t3i1b ON t3(a);
422 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
432 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
489 CREATE TRIGGER r1 AFTER INSERT ON orig.t1 BEGIN;
497 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
505 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
513 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
[all …]
H A Dconflict.test64 if {$conf!=""} {set conf "ON CONFLICT $conf"}
122 if {$conf!=""} {set conf "ON CONFLICT $conf"}
180 if {$conf!=""} {set conf "ON CONFLICT $conf"}
237 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
238 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
300 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
301 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
371 if {$conf1!=""} {set conf1 "ON CONFLICT $conf1"}
372 if {$conf2!=""} {set conf2 "ON CONFLICT $conf2"}
510 a INTEGER UNIQUE ON CONFLICT IGNORE,
[all …]
H A Djoin.test172 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
177 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
182 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
188 SELECT * FROM t1 NATURAL JOIN t2 ON t1.a=t2.b;
190 } {1 {a NATURAL join may not have an ON or USING clause}}
195 } {1 {a NATURAL join may not have an ON or USING clause}}
198 SELECT * FROM t1 JOIN t2 ON t1.a=t2.b USING(b);
200 } {1 {cannot have both ON and USING clauses in the same join}}
213 SELECT * FROM t1 JOIN t2 ON t3.a=t2.b;
348 SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
[all …]
H A Dversion.test99 CREATE INDEX i1 ON t1(x);
105 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
108 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN
111 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
114 CREATE TRIGGER r4 AFTER DELETE ON t2 FOR EACH ROW BEGIN
H A Dfkey1.test29 REFERENCES t1 ON DELETE CASCADE
32 FOREIGN KEY (b,c) REFERENCES t2(x,y) ON UPDATE CASCADE
H A Dnotnull.test28 c NOT NULL ON CONFLICT REPLACE DEFAULT 6,
29 d NOT NULL ON CONFLICT IGNORE DEFAULT 7,
30 e NOT NULL ON CONFLICT ABORT DEFAULT 8
266 CREATE INDEX t1a ON t1(a);
267 CREATE INDEX t1b ON t1(b);
268 CREATE INDEX t1c ON t1(c);
269 CREATE INDEX t1d ON t1(d);
270 CREATE INDEX t1e ON t1(e);
271 CREATE INDEX t1abc ON t1(a,b,c);
H A Dmalloc.test49 CREATE INDEX i1 ON t1(a,b);
90 CREATE INDEX i1 ON t1(a,b);
136 CREATE INDEX i1 ON t1(a,b);
171 CREATE INDEX i1 ON t1(a,b);
208 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
H A Dunique.test92 CREATE UNIQUE INDEX i2 ON t2(a)
128 CREATE UNIQUE INDEX i2 ON t2(a);
133 CREATE INDEX i2 ON t2(a);
/titanic_50/usr/src/lib/libbc/libc/stdio/common/
H A Dscanf.c40 #define ON 1 macro
63 == ON) { in scanf()
71 == ON) { in scanf()
98 == ON) { in fscanf()
106 == ON) { in fscanf()
131 == ON) { in sscanf()
139 == ON) { in sscanf()
263 return(ON); in format_arg()
/titanic_50/usr/src/lib/libprtdiag_psr/sparc/montecarlo/common/
H A Dmontecarlo.c193 #define ON "on" macro
1429 & 0xff), SCB_OK_BIT) ? ON:OFF); in display_mc_prtdiag_info()
1432 & 0xff), SCB_OK_BIT) ? ON:OFF; in display_mc_prtdiag_info()
1440 & 0xff), 0) ? ON:OFF); in display_mc_prtdiag_info()
1443 & 0xff), 0) ? ON:OFF; in display_mc_prtdiag_info()
1555 & 0xff), i) ? ON:OFF); in display_mc_prtdiag_info()
1558 & 0xff), i) ? ON:OFF; in display_mc_prtdiag_info()
1571 & 0xff), 0) ? ON:OFF); in display_mc_prtdiag_info()
1575 & 0xff), 0) ? ON:OFF; in display_mc_prtdiag_info()
1583 & 0xff), 1) ? ON:OFF); in display_mc_prtdiag_info()
[all …]
/titanic_50/usr/src/lib/libbc/libc/gen/common/
H A Dgetauditflags.c36 #define ON 1 macro
434 succ_event = ON; in getauditflagsbin()
435 fail_event = ON; in getauditflagsbin()
453 succ_event = ON; in getauditflagsbin()
461 fail_event = ON; in getauditflagsbin()
476 if (succ_event == ON) in getauditflagsbin()
480 if (fail_event == ON) in getauditflagsbin()
/titanic_50/usr/src/cmd/lp/filter/postscript/postcomm/
H A Dpostcomm.c108 # define ON 1 macro
299 debug = ON; in options()
303 ignore = ON; in options()
572 if (status[i].val != laststate || debug == ON) in getstatus()
/titanic_50/usr/src/cmd/lp/filter/postscript/common/
H A Dmisc.c162 return(ON);
166 return(ON);
H A Dgen.h44 #define ON 1 macro
/titanic_50/usr/src/cmd/tnf/prex/
H A Dprexlex.l91 on { yylval.intval = ON; return (ON); }
H A Dprexgram.y45 %token ON
306 pfilter_statement : PFILTER ON NL
318 ktrace_statement : KTRACE ON NL
/titanic_50/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.
89 If ONNV_BUILDNUM is set to an older ON build number,
100 pkgmogrify(1) use in ON.
179 If you did a full build, all ON packages will be updated.
187 Ask IPS to explicitly check if ON can be installed, and
350 The "slim_install" package may depend on ON packages. If it does,
351 you must send a FLAG DAY message for ON users and PIT who test
423 The following actions are required for all packages in ON.
455 global zones, non-global zones, or both. All ON packages are
[all …]
/titanic_50/usr/src/lib/krb5/plugins/kdb/ldap/libkdb_ldap/
H A Dldap_handle.c74 server_info->server_status = ON;
119 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()
/titanic_50/usr/src/uts/sun4u/montecarlo/sys/
H A Dscsb_led.h65 ON = 1, enumerator
/titanic_50/usr/src/cmd/lp/filter/postscript/postprint/
H A Dpostprint.c420 debug = ON; in options()
424 ignore = ON; in options()
916 if ( pg >= 0 && in_olist(pg) == ON ) in redirect()

12345678910>>...12