Home
last modified time | relevance | path

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

123456789

/titanic_44/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 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 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 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 …]
/titanic_44/usr/src/lib/libmvec/common/
H A D__vcos.c203 double t0, t1, t2, z0, z1, z2; in __vcos() local
211 HI(&t1) = j1; in __vcos()
214 LO(&t1) = 0; in __vcos()
217 x1 -= t1; in __vcos()
223 t1 = z1 * (qq1 + z1 * qq2); in __vcos()
239 t1 = __vlibm_TBL_sincos_lo[j1+1] - (__vlibm_TBL_sincos_hi[j1+xsb1]*w1 - a1*t1); in __vcos()
243 *py1 = a1 + t1; in __vcos()
250 HI(&t1) = j1; in __vcos()
252 LO(&t1) = 0; in __vcos()
254 x1 -= t1; in __vcos()
[all …]
H A D__vsin.c177 double t0, t1, t2, z0, z1, z2; in __vsin() local
185 HI(&t1) = j1; in __vsin()
188 LO(&t1) = 0; in __vsin()
191 x1 -= t1; in __vsin()
197 t1 = z1 * (qq1 + z1 * qq2); in __vsin()
212 t1 = (__vlibm_TBL_sincos_hi[j1+1] * w1 + a1 * t1) + __vlibm_TBL_sincos_lo[j1+xsb1]; in __vsin()
215 *py1 = a1 + t1; in __vsin()
222 HI(&t1) = j1; in __vsin()
224 LO(&t1) = 0; in __vsin()
226 x1 -= t1; in __vsin()
[all …]
H A D__vsincos.c233 double t0, t1, t2, t1_0, t1_1, t1_2, t2_0, t2_1, t2_2; in __vsincos() local
243 HI(&t1) = j1; in __vsincos()
246 LO(&t1) = 0; in __vsincos()
250 x1 -= t1; in __vsincos()
258 t1 = z1 * (qq1 + z1 * qq2); in __vsincos()
282 t2_1 = __vlibm_TBL_sincos_lo[j1+1] - (a1_1*w1 - a2_1*t1); in __vsincos()
290 t1_1 = a2_1*w1 + a1_1*t1; in __vsincos()
307 HI(&t1) = j1; in __vsincos()
309 LO(&t1) = 0; in __vsincos()
311 x1 -= t1; in __vsincos()
[all …]
H A D__vcosbig_ultra3.c226 double t0, t1, t2, z0, z1, z2; in __vlibm_vcos_big_ultra3() local
234 HI(&t1) = j1; in __vlibm_vcos_big_ultra3()
237 LO(&t1) = 0; in __vlibm_vcos_big_ultra3()
240 x1 = (x1 - t1) + y1; in __vlibm_vcos_big_ultra3()
246 t1 = z1 * (qq1 + z1 * qq2); in __vlibm_vcos_big_ultra3()
267 t1 = (__vlibm_TBL_sincos_hi[j1+((n1+xsb1)&3)] * w1 + a1 * t1) + __vlibm_TBL_sincos_lo[j1+n1]; in __vlibm_vcos_big_ultra3()
270 *py1 = ( a1 + t1 ); in __vlibm_vcos_big_ultra3()
278 HI(&t1) = j1; in __vlibm_vcos_big_ultra3()
280 LO(&t1) = 0; in __vlibm_vcos_big_ultra3()
286 x1 = (x1 - t1) + y1; in __vlibm_vcos_big_ultra3()
[all …]
/titanic_44/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 …]

123456789