Home
last modified time | relevance | path

Searched refs:t1 (Results 1 – 25 of 233) sorted by relevance

12345678910

/onnv-gate/usr/src/lib/libsqlite/test/
H A Dnotnull.test25 CREATE TABLE t1 (
32 SELECT * FROM t1;
37 DELETE FROM t1;
38 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
39 SELECT * FROM t1 order by a;
44 DELETE FROM t1;
45 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
46 SELECT * FROM t1 order by a;
48 } {1 {t1.a may not be NULL}}
51 DELETE FROM t1;
[all …]
H A Dexpr.test24 execsql {CREATE TABLE test1(i1 int, i2 int, r1 real, r2 real, t1 text, t2 text)}
163 test_expr expr-3.1 {t1='abc', t2='xyz'} {t1<t2} 1
164 test_expr expr-3.2 {t1='xyz', t2='abc'} {t1<t2} 0
165 test_expr expr-3.3 {t1='abc', t2='abc'} {t1<t2} 0
166 test_expr expr-3.4 {t1='abc', t2='xyz'} {t1<=t2} 1
167 test_expr expr-3.5 {t1='xyz', t2='abc'} {t1<=t2} 0
168 test_expr expr-3.6 {t1='abc', t2='abc'} {t1<=t2} 1
169 test_expr expr-3.7 {t1='abc', t2='xyz'} {t1>t2} 0
170 test_expr expr-3.8 {t1='xyz', t2='abc'} {t1>t2} 1
171 test_expr expr-3.9 {t1='abc', t2='abc'} {t1>t2} 0
[all …]
H A Dbigrow.test38 CREATE TABLE t1(a text, b text, c text);
43 } {t1}
47 set sql "INSERT INTO t1 VALUES('abc',"
50 execsql {SELECT a, c FROM t1}
53 execsql {SELECT b FROM t1}
57 set sql "INSERT INTO t1 VALUES('abc2',"
63 execsql {SELECT b FROM t1 ORDER BY c}
66 execsql {SELECT c FROM t1 ORDER BY c}
69 execsql {DELETE FROM t1 WHERE a='abc2'}
70 execsql {SELECT c FROM t1}
[all …]
H A Dselect4.test32 CREATE TABLE t1(n int, log int);
33 COPY t1 FROM 'data1.txt'
38 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
44 lsort [execsql {SELECT DISTINCT log FROM t1}]
47 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
51 SELECT DISTINCT log FROM t1
53 SELECT n FROM t1 WHERE log=3
60 SELECT DISTINCT log FROM t1
62 SELECT n FROM t1 WHERE log=3
71 SELECT DISTINCT log FROM t1
[all …]
H A Djoin.test25 CREATE TABLE t1(a,b,c);
26 INSERT INTO t1 VALUES(1,2,3);
27 INSERT INTO t1 VALUES(2,3,4);
28 INSERT INTO t1 VALUES(3,4,5);
29 SELECT * FROM t1;
44 SELECT * FROM t1 NATURAL JOIN t2;
46 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
49 SELECT * FROM t2 NATURAL JOIN t1;
51 } {t2.b 2 t2.c 3 t2.d 4 t1.a 1 t2.b 3 t2.c 4 t2.d 5 t1.a 2}
54 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
[all …]
H A Dintpkey.test29 CREATE TABLE t1(a TEXT PRIMARY KEY, b, c);
38 WHERE type='index' AND tbl_name='t1';
40 } {{(t1 autoindex 1)}}
47 DROP TABLE t1;
48 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
50 WHERE type='index' AND tbl_name='t1';
59 INSERT INTO t1 VALUES(5,'hello','world');
65 SELECT * FROM t1;
70 SELECT rowid, * FROM t1;
79 INSERT INTO t1 VALUES(5,'second','entry');
[all …]
H A Dfunc.test25 execsql {CREATE TABLE tbl1(t1 text)}
29 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
46 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
57 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
58 ORDER BY length(t1)}
67 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
[all …]
H A Dformat3.test28 puts $fd "2\ttwo\t1\tII\t2.15"
29 puts $fd "3\tthree\t1\tIII\t4221.0"
37 CREATE TABLE t1(
44 COPY t1 FROM 'data.txt'
56 execsql {SELECT count(*) FROM t1}
60 execsql {SELECT n FROM t1 ORDER BY n}
63 execsql {SELECT n FROM t1 ORDER BY n ASC}
66 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
69 execsql {SELECT n FROM t1 ORDER BY n DESC}
72 execsql {SELECT v FROM t1 ORDER BY v}
[all …]
H A Dwhere.test26 CREATE TABLE t1(w int, x int, y int);
33 execsql "INSERT INTO t1 VALUES($w,$x,$y)"
36 INSERT INTO t2 SELECT 101-w, x, (SELECT max(y) FROM t1)+1-y, y FROM t1;
37 CREATE INDEX i1w ON t1(w);
38 CREATE INDEX i1xy ON t1(x,y);
58 count {SELECT x, y FROM t1 WHERE w=10}
61 count {SELECT x, y FROM t1 WHERE w=11}
64 count {SELECT x, y FROM t1 WHERE 11=w}
67 count {SELECT x, y FROM t1 WHERE 11=w AND x>2}
70 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
[all …]
H A Drowid.test27 CREATE TABLE t1(x int, y int);
28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
30 SELECT x FROM t1 ORDER BY y;
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
[all …]
H A Dselect6.test26 CREATE TABLE t1(x, y);
27 INSERT INTO t1 VALUES(1,1);
28 INSERT INTO t1 VALUES(2,2);
29 INSERT INTO t1 VALUES(3,2);
30 INSERT INTO t1 VALUES(4,3);
31 INSERT INTO t1 VALUES(5,3);
32 INSERT INTO t1 VALUES(6,3);
33 INSERT INTO t1 VALUES(7,3);
34 INSERT INTO t1 VALUES(8,4);
35 INSERT INTO t1 VALUES(9,4);
[all …]
H A Dprogress.test26 CREATE TABLE t1(a);
27 INSERT INTO t1 VALUES(1);
28 INSERT INTO t1 VALUES(2);
29 INSERT INTO t1 VALUES(3);
30 INSERT INTO t1 VALUES(4);
31 INSERT INTO t1 VALUES(5);
32 INSERT INTO t1 VALUES(6);
33 INSERT INTO t1 VALUES(7);
34 INSERT INTO t1 VALUES(8);
35 INSERT INTO t1 VALUES(9);
[all …]
H A Dconflict.test28 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
30 SELECT c FROM t1 ORDER BY c;
38 # cmd An INSERT or REPLACE command to execute against table t1
40 # t1 Content of "c" column of t1 assuming no error in $cmd
43 foreach {i conf cmd t0 t1 t2} {
66 DELETE FROM t1;
68 INSERT INTO t1 VALUES(1,2,3);
71 $cmd INTO t1 VALUES(1,2,4);
74 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
77 } [list $t0 $t1 $t2]
[all …]
H A Dselect3.test33 CREATE TABLE t1(n int, log int);
34 COPY t1 FROM 'data1.txt'
37 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
43 execsql {SELECT count(*) FROM t1}
48 FROM t1
52 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
58 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
61 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
64 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
67 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
[all …]
H A Dioerr.test41 CREATE TABLE t1(a,b,c);
44 INSERT INTO t1 VALUES(1,2,3);
45 INSERT INTO t1 VALUES(4,5,6);
47 SELECT * FROM t1;
49 INSERT INTO t1 VALUES(1,2,3);
50 INSERT INTO t1 VALUES(4,5,6);
52 SELECT * FROM t1;
53 DELETE FROM t1 WHERE a<100;
85 CREATE TABLE t1(a, b, c);
86 INSERT INTO t1 VALUES(1, randstr(5,50), randstr(5,50));
[all …]
H A Djoin4_28.test26 create temp table t1(a integer, b varchar(10));
27 insert into t1 values(1,'one');
28 insert into t1 values(2,'two');
29 insert into t1 values(3,'three');
30 insert into t1 values(4,'four');
37 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
42 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
50 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
55 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
60 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
[all …]
H A Din.test31 CREATE TABLE t1(a int, b int);
32 COPY t1 FROM 'data1.txt';
35 execsql {SELECT count(*) FROM t1}
41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
63 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
[all …]
H A Dmisuse.test31 CREATE TABLE t1(a,b);
32 INSERT INTO t1 VALUES(1,2);
34 sqlite_exec_printf $::DB {SELECT * FROM t1} {}
37 sqlite_exec_printf $::DB {SELECT x_coalesce(NULL,a) AS 'xyz' FROM t1} {}
41 sqlite_exec_printf $::DB {SELECT x_coalesce(NULL,a) AS 'xyz' FROM t1} {}
53 SELECT x_sqlite_exec('SELECT * FROM t1') AS xyz;
57 sqlite_exec_printf $::DB {SELECT * FROM t1} {}
61 SELECT * FROM t1
71 SELECT * FROM t1
75 sqlite_exec_printf $::DB {SELECT * FROM t1} {}
[all …]
H A Dbigfile.test30 # This is the md5 checksum of all the data in table t1 as created
39 CREATE TABLE t1(x);
40 INSERT INTO t1 VALUES('abcdefghijklmnopqrstuvwxyz');
41 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
42 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
43 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
44 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
45 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
46 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
47 INSERT INTO t1 SELECT rowid || ' ' || x FROM t1;
[all …]
H A Dmalloc.test45 CREATE TABLE t1(
49 CREATE INDEX i1 ON t1(a,b);
50 INSERT INTO t1 VALUES(1,2.3,4.5,'hi','there');
51 INSERT INTO t1 VALUES(6,7.0,0.8,'hello','out yonder');
52 SELECT * FROM t1;
53 SELECT avg(b) FROM t1 GROUP BY a HAVING b>20.0;
54 DELETE FROM t1 WHERE a IN (SELECT min(a) FROM t1);
55 SELECT count(*) FROM t1;
89 CREATE TABLE t1(a int, b int, c int);
90 CREATE INDEX i1 ON t1(a,b);
[all …]
H A Dversion.test30 CREATE TABLE t1(x);
31 INSERT INTO t1 VALUES(1);
32 INSERT INTO t1 SELECT x+1 FROM t1;
33 INSERT INTO t1 SELECT x+2 FROM t1;
34 INSERT INTO t1 SELECT x+4 FROM t1;
35 SELECT * FROM t1;
72 SELECT * FROM t1;
86 SELECT * FROM t1;
99 CREATE INDEX i1 ON t1(x);
100 DELETE FROM t1;
[all …]
H A Dsubselect.test27 CREATE TABLE t1(a int, b int);
28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
30 INSERT INTO t1 VALUES(5,6);
32 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
38 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
45 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
[all …]
/onnv-gate/usr/src/common/openssl/crypto/aes/
H A Daes_core.c900 u32 s0, s1, s2, s3, t0, t1, t2, t3; in AES_encrypt() local
919 t1 = Te0[s1 >> 24] ^ Te1[(s2 >> 16) & 0xff] ^ Te2[(s3 >> 8) & 0xff] ^ Te3[s0 & 0xff] ^ rk[ 5]; in AES_encrypt()
923 s0 = Te0[t0 >> 24] ^ Te1[(t1 >> 16) & 0xff] ^ Te2[(t2 >> 8) & 0xff] ^ Te3[t3 & 0xff] ^ rk[ 8]; in AES_encrypt()
924 s1 = Te0[t1 >> 24] ^ Te1[(t2 >> 16) & 0xff] ^ Te2[(t3 >> 8) & 0xff] ^ Te3[t0 & 0xff] ^ rk[ 9]; in AES_encrypt()
925 s2 = Te0[t2 >> 24] ^ Te1[(t3 >> 16) & 0xff] ^ Te2[(t0 >> 8) & 0xff] ^ Te3[t1 & 0xff] ^ rk[10]; in AES_encrypt()
926 s3 = Te0[t3 >> 24] ^ Te1[(t0 >> 16) & 0xff] ^ Te2[(t1 >> 8) & 0xff] ^ Te3[t2 & 0xff] ^ rk[11]; in AES_encrypt()
929 t1 = Te0[s1 >> 24] ^ Te1[(s2 >> 16) & 0xff] ^ Te2[(s3 >> 8) & 0xff] ^ Te3[s0 & 0xff] ^ rk[13]; in AES_encrypt()
933 s0 = Te0[t0 >> 24] ^ Te1[(t1 >> 16) & 0xff] ^ Te2[(t2 >> 8) & 0xff] ^ Te3[t3 & 0xff] ^ rk[16]; in AES_encrypt()
934 s1 = Te0[t1 >> 24] ^ Te1[(t2 >> 16) & 0xff] ^ Te2[(t3 >> 8) & 0xff] ^ Te3[t0 & 0xff] ^ rk[17]; in AES_encrypt()
935 s2 = Te0[t2 >> 24] ^ Te1[(t3 >> 16) & 0xff] ^ Te2[(t0 >> 8) & 0xff] ^ Te3[t1 & 0xff] ^ rk[18]; in AES_encrypt()
[all …]
/onnv-gate/usr/src/cmd/acct/
H A Dacctmerg.c190 tacctadd(struct tacct *t1, struct tacct *t2) in tacctadd() argument
192 t1->ta_cpu[0] = t1->ta_cpu[0] + t2->ta_cpu[0]; in tacctadd()
193 t1->ta_cpu[1] = t1->ta_cpu[1] + t2->ta_cpu[1]; in tacctadd()
194 t1->ta_kcore[0] = t1->ta_kcore[0] + t2->ta_kcore[0]; in tacctadd()
195 t1->ta_kcore[1] = t1->ta_kcore[1] + t2->ta_kcore[1]; in tacctadd()
196 t1->ta_con[0] = t1->ta_con[0] + t2->ta_con[0]; in tacctadd()
197 t1->ta_con[1] = t1->ta_con[1] + t2->ta_con[1]; in tacctadd()
198 t1->ta_du = t1->ta_du + t2->ta_du; in tacctadd()
199 t1->ta_pc += t2->ta_pc; in tacctadd()
200 t1->ta_sc += t2->ta_sc; in tacctadd()
[all …]
/onnv-gate/usr/src/lib/libtnfctl/
H A Ddbg.h55 #define DBG_TNF_PROBE_1(a, b, c, t1, n1, v1) \ argument
56 TNF_PROBE_1(a, b, c, t1, n1, v1)
57 #define DBG_TNF_PROBE_2(a, b, c, t1, n1, v1, t2, n2, v2) \ argument
58 TNF_PROBE_2(a, b, c, t1, n1, v1, t2, n2, v2)
59 #define DBG_TNF_PROBE_3(a, b, c, t1, n1, v1, t2, n2, v2, t3, n3, v3) \ argument
60 TNF_PROBE_3(a, b, c, t1, n1, v1, t2, n2, v2, t3, n3, v3)
62 #define DBG_TNF_PROBE_4(a, b, c, t1, n1, v1, t2, n2, v2, t3, n3, v3, t4, n4, v4) \ argument
63 TNF_PROBE_4(a, b, c, t1, n1, v1, t2, n2, v2, t3, n3, v3, t4, n4, v4)
69 #define DBG_TNF_PROBE_1(a, b, c, t1, n1, v1) \
71 #define DBG_TNF_PROBE_2(a, b, c, t1, n1, v1, t2, n2, v2) \
[all …]

12345678910