Home
last modified time | relevance | path

Searched refs:t2 (Results 26 – 50 of 230) sorted by relevance

12345678910

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dhook.test43 CREATE TABLE t2(a,b);
49 INSERT INTO t2 VALUES(1,2);
50 INSERT INTO t2 SELECT a+1, b+1 FROM t2;
51 INSERT INTO t2 SELECT a+2, b+2 FROM t2;
58 set ::commit_cnt [execsql {SELECT * FROM t2}]
62 INSERT INTO t2 VALUES(5,6);
69 set ::commit_cnt [execsql {SELECT * FROM t2}]
73 INSERT INTO t2 VALUES(6,7);
80 execsql {SELECT * FROM t2}
H A Dtrigger1.test224 SELECT * FROM t2;
236 SELECT * FROM t2;
243 SELECT * FROM t2;
258 DROP TABLE t2;
319 } {view v1 table t2}
322 CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
327 } {view v1 table t2 trigger t2}
338 } {view v1 table t2 trigger t2}
341 DROP TRIGGER t2;
344 } {view v1 table t2}
[all …]
H A Dattach.test38 CREATE TABLE t2(x,y);
41 SELECT * FROM t2;
52 SELECT * FROM t2;
63 SELECT * FROM t2;
249 } {table t2 t2 table tx tx trigger r1 t2}
263 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
286 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
294 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
307 SELECT * FROM t2
313 SELECT * FROM t2
[all …]
H A Djoin2.test32 CREATE TABLE t2(b,c);
33 INSERT INTO t2 VALUES(11,111);
34 INSERT INTO t2 VALUES(33,333);
35 INSERT INTO t2 VALUES(44,444);
36 SELECT * FROM t2;
52 t1 NATURAL JOIN t2 NATURAL JOIN t3
58 t1 NATURAL JOIN t2 NATURAL LEFT OUTER JOIN t3
64 t1 NATURAL LEFT OUTER JOIN t2 NATURAL JOIN t3
70 t1 NATURAL LEFT OUTER JOIN (t2 NATURAL JOIN t3)
H A Dlaststmtchanges.test98 select v1 from t2;
105 select v2 from t2;
116 delete from t2; delete from t2;
130 select v1 from t2;
137 select v2 from t2;
148 delete from t2; delete from t2;
162 select v1 from t2;
169 select v2 from t2;
178 drop table t0; drop table t1; drop table t2;
183 create temp view v2 as select * from t2;
[all …]
H A Dmemdb.test165 # t2 Content of "x" column of t2
191 DELETE FROM t2;
201 } [list $t0 $t1 $t2]
206 DROP TABLE t2;
280 SELECT * FROM t2;
286 DROP TABLE t2;
295 } {t1 t2 t3 t4}
298 SELECT * FROM t2;
303 SELECT a FROM t2 UNION SELECT b FROM t2 ORDER BY 1;
329 } {t1 t2 t3 t4 t5}
[all …]
H A Dview.test190 CREATE TABLE t2(y,a);
191 INSERT INTO t2 VALUES(22,2);
192 INSERT INTO t2 VALUES(33,3);
193 INSERT INTO t2 VALUES(44,4);
194 INSERT INTO t2 VALUES(55,5);
195 SELECT * FROM t2;
201 SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
215 SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
353 INSERT INTO t2 SELECT * FROM t2 WHERE a<5;
354 INSERT INTO t2 SELECT * FROM t2 WHERE a<4;
[all …]
H A Dupdate.test511 INSERT INTO t2 SELECT a+2 FROM t2;
512 INSERT INTO t2 SELECT a+4 FROM t2;
513 INSERT INTO t2 SELECT a+8 FROM t2;
514 INSERT INTO t2 SELECT a+16 FROM t2;
515 INSERT INTO t2 SELECT a+32 FROM t2;
516 INSERT INTO t2 SELECT a+64 FROM t2;
517 INSERT INTO t2 SELECT a+128 FROM t2;
518 INSERT INTO t2 SELECT a+256 FROM t2;
519 INSERT INTO t2 SELECT a+512 FROM t2;
520 INSERT INTO t2 SELECT a+1024 FROM t2;
[all …]
H A Dselect6.test101 CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
102 INSERT INTO t2 SELECT * FROM t1;
103 SELECT DISTINCT b FROM t2 ORDER BY b;
110 execsql {SELECT count(*) FROM (SELECT b FROM t2)}
126 (SELECT max(a),b FROM t2 GROUP BY b) as b
134 (SELECT max(a),b FROM t2 GROUP BY b) as b
391 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
399 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
407 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
416 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
[all …]
H A Dselect4.test57 CREATE TABLE t2 AS
62 SELECT * FROM t2;
65 execsql {DROP TABLE t2}
68 CREATE TABLE t2 AS
73 SELECT * FROM t2;
76 execsql {DROP TABLE t2}
86 CREATE TABLE t2 AS
90 SELECT * FROM t2;
157 SELECT * FROM t2;
168 SELECT * FROM t2;
[all …]
H A Dunique.test82 CREATE TABLE t2(a int, b int);
83 INSERT INTO t2(a,b) VALUES(1,2);
85 SELECT * FROM t2 ORDER BY a;
90 CREATE UNIQUE INDEX i2 ON t2(a)
95 SELECT * FROM t2 ORDER BY a
100 INSERT INTO t2 VALUES(1,5);
105 SELECT * FROM t2 ORDER BY a
111 SELECT * FROM t2 ORDER BY a;
116 INSERT INTO t2 VALUES(1,5)
121 SELECT * FROM t2 ORDER BY a, b;
[all …]
H A Dtrans.test328 } {i2a i2b t2}
366 } {i2x i2y t1 t2}
374 } {i2x i2y t1 t2}
389 DROP TABLE t2;
408 } {i2x i2y t1 t2}
703 DELETE FROM t2;
711 INSERT INTO t2 SELECT * FROM t2;
719 DELETE FROM t2;
727 INSERT INTO t2 SELECT * FROM t2;
774 DROP TABLE t2;
[all …]
H A Dmisc3.test41 CREATE TABLE t2(x,y);
49 DROP TABLE t2;
110 CREATE TABLE t2(a INT UNIQUE);
116 INSERT INTO t2 VALUES(2147483648);
122 INSERT INTO t2 VALUES(-2147483649);
128 INSERT INTO t2 VALUES(+2147483649);
134 INSERT INTO t2 VALUES(+2147483647);
135 INSERT INTO t2 VALUES(-2147483648);
136 INSERT INTO t2 VALUES(-2147483647);
137 INSERT INTO t2 VALUES(2147483646);
[all …]
/illumos-gate/usr/src/lib/librstp/common/
H A Dtimes.c28 STP_compare_times (IN TIMEVALUES_T *t1, IN TIMEVALUES_T *t2) in STP_compare_times() argument
30 if (t1->MessageAge < t2->MessageAge) return -1; in STP_compare_times()
31 if (t1->MessageAge > t2->MessageAge) return 1; in STP_compare_times()
33 if (t1->MaxAge < t2->MaxAge) return -2; in STP_compare_times()
34 if (t1->MaxAge > t2->MaxAge) return 2; in STP_compare_times()
36 if (t1->ForwardDelay < t2->ForwardDelay) return -3; in STP_compare_times()
37 if (t1->ForwardDelay > t2->ForwardDelay) return 3; in STP_compare_times()
39 if (t1->HelloTime < t2->HelloTime) return -4; in STP_compare_times()
40 if (t1->HelloTime > t2->HelloTime) return 4; in STP_compare_times()
/illumos-gate/usr/src/lib/libdemangle/common/
H A Dcxx.c378 t = t2; in parse_encoding()
394 t = t2; in parse_encoding()
726 t2 = parse_discriminator(t2, last); in parse_local_name()
1296 if (t2[0] != 'p' && t2[1] != 'i') in parse_new_expr()
1303 while (t2[0] != 'E' && t2 != last) { in parse_new_expr()
1987 if (t2 == last || t2[0] != 'p') in parse_function_param()
1997 if (t2 == last || t2[0] != '_') in parse_function_param()
2475 while (t2 != last && t2[0] != '_') { in parse_unnamed_type_name()
3492 if (t2 == t || t2 == last) in parse_unresolved_name()
3546 if (t2 == t || t2 == last) in parse_unresolved_name()
[all …]
/illumos-gate/usr/src/lib/libm/common/complex/
H A Dk_clog_r.c279 t2 = y * y; in __k_clog_r()
285 return (half * t2); in __k_clog_r()
342 t1 = x * x; t2 = y * y; in __k_clog_r()
346 z = t1+t2; in __k_clog_r()
369 if (t2 >= fabs(t3)) { in __k_clog_r()
374 wh = t2; t2 = t3; t3 = wh; in __k_clog_r()
381 zh = ((tk + t2) + t3) + t4; in __k_clog_r()
384 if (w >= fabs(t2)) in __k_clog_r()
385 *er = (((tk - zh) + t2) + t3) + t4; in __k_clog_r()
389 wh = (t1 - wh) - (wh - t2); in __k_clog_r()
[all …]
H A Dk_clog_rl.c449 t2 = y * y;
460 return (half * t2);
525 t1 = x * x; t2 = y * y;
542 z = t1+t2;
580 if (t2 >= fabsl(t3)) {
585 wh = t2; t2 = t3; t3 = wh;
592 zh = ((tk + t2) + t3) + t4;
609 if (w >= fabsl(t2))
611 *er = (((tk - zh) + t2) + t3) + t4;
618 wh = (t1 - wh) - (wh - t2);
[all …]
/illumos-gate/usr/src/cmd/acct/
H A Dacctmerg.c189 tacctadd(struct tacct *t1, struct tacct *t2) in tacctadd() argument
191 t1->ta_cpu[0] = t1->ta_cpu[0] + t2->ta_cpu[0]; in tacctadd()
192 t1->ta_cpu[1] = t1->ta_cpu[1] + t2->ta_cpu[1]; in tacctadd()
193 t1->ta_kcore[0] = t1->ta_kcore[0] + t2->ta_kcore[0]; in tacctadd()
195 t1->ta_con[0] = t1->ta_con[0] + t2->ta_con[0]; in tacctadd()
196 t1->ta_con[1] = t1->ta_con[1] + t2->ta_con[1]; in tacctadd()
197 t1->ta_du = t1->ta_du + t2->ta_du; in tacctadd()
198 t1->ta_pc += t2->ta_pc; in tacctadd()
199 t1->ta_sc += t2->ta_sc; in tacctadd()
200 t1->ta_dc += t2->ta_dc; in tacctadd()
[all …]
/illumos-gate/usr/src/lib/libm/common/Q/
H A Dhypotl.c69 long double t1, t2, y1, y2, w; in hypotl() local
110 t2 = x - t1; in hypotl()
111 x = sqrtl(t1 * t1 - (y * (-y) - t2 * (x + t1))); in hypotl()
121 t2 = x - t1; in hypotl()
122 x = sqrtl(t1 * y1 - (w * (-w) - (t2 * y1 + y2 * x))); in hypotl()
130 t2 = x; in hypotl()
132 t2 = y; in hypotl()
134 t2 = x + y; /* invalid if x or y is sNaN */ in hypotl()
135 return (t2); in hypotl()
/illumos-gate/usr/src/lib/libc/port/locale/
H A Dstrcoll.c53 wchar_t *t1 = NULL, *t2 = NULL; in strcoll_l() local
81 if ((t2 = malloc(sz2 * sizeof (wchar_t))) == NULL) in strcoll_l()
83 w2 = t2; in strcoll_l()
98 if (t2) in strcoll_l()
99 free(t2); in strcoll_l()
106 if (t2) in strcoll_l()
107 free(t2); in strcoll_l()
/illumos-gate/usr/src/cmd/acct/lib/
H A Dtmsecs.c35 tmsecs(t1, t2) in tmsecs() argument
36 register struct tm *t1, *t2; in tmsecs()
38 return((t2->tm_sec - t1->tm_sec) +
39 60*(t2->tm_min - t1->tm_min) +
40 3600L*(t2->tm_hour - t1->tm_hour));
H A Dpnpsplit.c310 tmsecs(struct tm *t1, struct tm *t2) in tmsecs() argument
312 return((t2->tm_sec - t1->tm_sec) + in tmsecs()
313 60*(t2->tm_min - t1->tm_min) + in tmsecs()
314 3600L*(t2->tm_hour - t1->tm_hour)); in tmsecs()
323 tmless(struct tm *t1, struct tm *t2) in tmless() argument
325 if (t1->tm_hour != t2->tm_hour) in tmless()
326 return(t1->tm_hour < t2->tm_hour); in tmless()
327 if (t1->tm_min != t2->tm_min) in tmless()
328 return(t1->tm_min < t2->tm_min); in tmless()
329 return(t1->tm_sec < t2->tm_sec); in tmless()
/illumos-gate/usr/src/contrib/ast/src/cmd/ksh93/tests/
H A Dheredoc.sh297 cat > $tmp/functions/t2 <<\!!!
298 function t2 function
309 1 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
326 2 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
343 3 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
360 4 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
377 5 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
394 6 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
411 7 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
428 8 34567890 $(t2 1234567890 ) 0123456789012345678901234567890123
[all …]
/illumos-gate/usr/src/cmd/ast/libshell/common/tests/
H A Dillumos_13434_chunked_heredoc.sh133 t2=`mktemp`
134 if [[ ! -f "$t1" || ! -f "$t2" ]]; then
144 cat > "$t2" << EOF
148 if ! cmp -s "$t1" "$t2"; then
154 rm -f "$t1" "$t2"
/illumos-gate/usr/src/cmd/make/include/mksh/
H A Ddefs.h906 return ((t1.tv_sec == t2.tv_sec) && (t1.tv_nsec == t2.tv_nsec));
911 return ((t1.tv_sec != t2.tv_sec) || (t1.tv_nsec != t2.tv_nsec));
916 if (t1.tv_sec == t2.tv_sec) {
917 return (t1.tv_nsec > t2.tv_nsec);
919 return (t1.tv_sec > t2.tv_sec);
924 if (t1.tv_sec == t2.tv_sec) {
927 return (t1.tv_sec > t2.tv_sec);
932 if (t1.tv_sec == t2.tv_sec) {
935 return (t1.tv_sec < t2.tv_sec);
940 if (t1.tv_sec == t2.tv_sec) {
[all …]

12345678910